Compare and Append related Complex Requirement - How to do this in Alteryx

[BeingHappy]

Hello

I have got a csv file with just 2 columns inside it.

I need to make use of another csv file which has a comparison table inside it for creating a third column inside my original data file.

I have explained the requirement visually along with the data in the attached excel file.

Can someone please suggest, how this type of work could be done in Alteryx. I tried using "Find and Replace Tool", but I am not sure, how that can be used in this case, because I have to compare the value with multiple columns given inside the comparison table and assign the new values accordingly.

I have attached the sample data file containing very small number of rows. Actual files have millions of rows in each file. If any more information is needed from my side, then please let me know.

Thanks and Best Regards

 

[atcodedog05 · Accepted solution]

Hi @BeingHappy 

Here is how you can do it.

Workflow:

Hope this helps : )

[BeingHappy]

You are Awesome!

Thank you so much.

[atcodedog05]

Happy to help : ) @BeingHappy 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!