Question on Vlookup

[vrajgopal]

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

[RolandSchubert]

Hi @vrajgopal ,

you can use both the Join tool and the Find Replace tool to do the job. I've modified your workflow and added both approaches. Hope this is helpful.

Best,

Roland

[vrajgopal]

Hi Roland,

It worked for a small set of data. However when i used a large set it gave incorrect data.

For e.g country "Bahrain" already mapped to India in master sheet. After the workflow is completed it has bee remapped as "OTT" as per lookup sheet. 

I think it is skipping the first step of checking if it is "AP Sales Operation" in column “End Customer Sales Org – Area” .

I am trying to do a lookup only if it is AP Sales Operation in “End Customer Sales Org – Area”

Hope I am making sense.

I have attached a larger data set.

[OllieClarke · Accepted solution]

Hi @vrajgopal this workflow I think does what you're after:

Hope that helps,

Ollie

[vrajgopal]

Thank you it works perfectly