I have question on how to do Vlookup in Alteryx
In the attached workflow I have written a formula. The formula is giving the desired result but the if condition is increasing as data size is increasing.
I was hoping to solve the problem by using a vlookup which do the below steps.
Step 1 - In master sheet select “AP SALES OPERATIONS” in Column “End Customer Sales Org – Area”
Step 2 Take the country details from End Customer - Country (Text)
Step3 – Search for the country in lookup sheet in column “End Customer - Country (Text)”
Step4 – If found then take the details from “region” column
Step 5 – replace the details in column “End Customer Sales Org – Area” of master sheet with the data from “Region” column in lookup sheet.
Tried using “Find and Replace” and join but not getting the results I want.
Attaching the raw data and the lookup sheet I want to use.
Vishwanath
