Hi experts,
I'm trying to do a lookup between two tables. The report is not in a friendly format. However, the report will be consistent (always the same column and rows where it starts from). I need to find out the new companies in the 2020 table compared to 2019 table. The companies will always starts from "Row 10" and "column C" (I highlighted in yellow) I have attached both files for your consideration.
I can do H-Lookup in excel to find out the new companies we added (if any) in 2020 but I wanted to utilize Alteryx and learn how to do a workflow for this purpose.
Hope you can help.
Solved! Go to Solution.
As always, thank you so very much. This is exactly what I wanted. I very much appreciated. Have a great weekend.