Lookup and Replace data from different columns

[mjh418]

Hi All,

Thank you for reading.

Please see attached for easier understanding.

I have 3 items ( a result, a key map, and a source file).

Item A has data with date column and other columns A, B, C with data in each of those columns.

B has data with date column and other columns Apple, Banana, and Corn with data in each of those columns.

C is a simple file that has a mapping table(2 columns titled Name and Key) where A = Apple, B = Banana, C = Corn.

Expected outcome is where it returns Column A B C (like file A) but the data in those columns are from Apple, Banana, and Corn instead (file B).

I want to remind that removing file C (mapping table) is out of the question since the situation requires it. I have to somehow find a way using all 3.
Thank you so much for your help and time.

[messi007]

@mjh418,

Please see below:

Attached the workflow,

Hope this helps,

Regards

[shreyanshrathod]

@mjh418 ,

This should help. You can modify as per your exact requirement.

Regards,

Shreyansh Rathod