How to apply a vloop up in existing workflow

[NehaNevrekar]

Hi,

Please help me to apply Vlook-up for the attached file. Below is the columns for which Vlook-up is to be applied:

Attaching the relevant files.

Sr. No	Source File - Column	. Vlook up File - Column 1	Vlook up File - Column 2
1	N Sep20 – Invoice Num	Sales Report – Standard rated value	N Sep20 - COUNTRY_CURR_AMT

Would appreciate an immediate reply.

Thank you!

Regards,

Neha 

[AkimasaKajitani]

You can use Join tool to vlookup.

But there is the problem.

2 record of N Sep20.xlsx have the same Invoice num, so the data is multiplying at Join tool.

You can use unique tool to remove the data. But I don't know how to handle ”N Sep20.xlsx”.

Please refer attached file.

[NehaNevrekar]

Hi,

Thank you for the quick reply. Can you also show for both the columns? 

[AkimasaKajitani]

Hi,

Record 12 and 13 are the same invoice num.

[NehaNevrekar]

Hey AK,

That's fine. It will sum up right?

Can you just help me with workflow - how to apply vlook up for the below two columns along with the first vlook up in the same workflow itself.

. Vlook up File - Column 1	Vlook up File - Column 1
Sales Report – Standard rated value	N Sep20 - COUNTRY_CURR_AMT

Thank you!

Regards,

Neha

[AkimasaKajitani]

I sum up them by Summarize tool.

This is result.

I'm sure that vlookup has already accomplished.

Is this different from what you want?

[NehaNevrekar]

Hey Hi AK,

I am not getting the same output which you showed below. I can't see 'The country curr. amt' and 'VAT amt' in the final output. 

Can you please tell me how did you get this?

and also the below table

[AkimasaKajitani]

Hi @NehaNevrekar 

Do you use my workflow that I attach at previous reply?

Or please share your workflow.

[NehaNevrekar]

Yes! I referred your previous workflow.

I am attaching my workflow and the output.

[AkimasaKajitani · Accepted solution]

Hi @NehaNevrekar 

At the Select tool, required fields didn't come into output because "Unknown" is not checked.

Please use attached file.