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.

[atcodedog05]

Thank you for marking my post as solution🙂

Happy to help 🙂 @sriniprad08 

Cheers and Happy Analyzing 😀

[sriniprad08]

hi @atcodedog05  one more help as a part of Output B is it possible to create one more column

1) if the id in File B is present in File A based on if price is present for that particular Id then create an new column called Indicator stating yes nor no?

For eg.

id (File A)	Id (File B)	Price	Indicator
1	1	23	Yes
1	1	24	ys
2	2	25	yes
3	3	26	yes
3	3	27	yes
4	#N/A	28	No
Since Id from File B is not present in A so the indicator is No.

[Emil_Kos · Accepted solution]

Hi @sriniprad08,

I have prepared a workflow for you:

Output:

[atcodedog05 · Accepted solution]

Hi @sriniprad08 

Here is the modified workflow.

Output:

Workflow:

Hope this helps 🙂

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

[atcodedog05]

Happy to help 🙂 @sriniprad08 

Cheers and Happy Analyzing 😀

Feels free to ask more questions if you have any.

[sriniprad08]

Sure thank you @atcodedog05  🙂