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.