Creating a Pivot and bringing multiple columns and doing vlookup

[sriniprad08]

Hi Team,

Two things i would like my workflow to do.

1) Create a pivot on the File A with below format output.

2) Vlookup on the file A with file B with the common key as ID.

3) Final output where ids are matching in A and B.

I have created a pivot but i am not sure how to bring "Vendor name" into the final output.

[Emil_Kos]

Hi @sriniprad08,

If you are asking about output B I believe you need to use join tool and join the data on the ID column 

[Emil_Kos · Accepted solution]

Hi @sriniprad08,

I have prepared a mock-up for you.

and the output:

Please mark as an answer it is something helpful

[sriniprad08]

hi @Emil_Kos ,

Thank you. How can i solve Output A. Where I need to bring Vendor name as well?

Cheers,

Sriniv

[atcodedog05]

Hi @sriniprad08 

Sorry my bad to get vendor name also.

Just select column in join tool.

But it looks more like a grouby ID & name and sum of cost. Numbers match.

[Emil_Kos · Accepted solution]

Hi @sriniprad08,

Please let me know if this the desired output:

[Emil_Kos]

Hi @sriniprad08

Thank you for marking my post as an answer.

Highly appreciate!

[atcodedog05 · Accepted solution]

Hi @sriniprad08 

I would suggest using find and replace instead of join for vlookup.

Join will create 1-many match there by creating multiple rows

Here is the workflow

Output A:

Output B: Find and replace

Join: creates more rows.

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[sriniprad08]

Thank you @Emil_Kos . Really helpful

[sriniprad08]

Thank you @atcodedog05  Perfect 👌