Compare and Append related Complex Requirement - How to do this in Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
 
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You are Awesome!
Thank you so much.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @Aakash55
If my response helps please don't forget to mark it as solution.
Cheers and have a nice day!
