cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Vlookup betwen two tables

SL12345
New Contributor III

Hi snaplogic experts,
lets say i have excel(A) with 10 values in one column (branches) on left side and on the right side i have excel(B) with two columns (branches and managers). iam able to read them separately โ€ฆ but how can i create something like vlookup - if values from excel B (column A) are in excel A, then replace value in excel A with value from column2 from excel B ?

Example:

     Excel A                                 
New York                          
Washington                        
Los Angeles
Hollywood


      Excel B
New York    Test1
Washington  Test2


Result should be: 

Test1
Test2
Los Angeles
Hollywood

i dont mean whole solution, but which snap/function should i use?

Thank you

1 ACCEPTED SOLUTION

Sharing some snaps, sample pipeline and files for your convenience:

image

image

Branches.xlsx (9.7 KB)
Branches_Managers.xlsx (9.1 KB)
Branches_Managers_2022_11_23.slp (12.7 KB)

Regards,
Darsh

View solution in original post

4 REPLIES 4

darshthakkar
Valued Contributor

Hi @SL12345,

There are a couple of snaps you can use to achieve your end results. Snaps like mapper, conditional formatting and join would help you out.

Easier solution without writing any transformation rules would be a Join. If youโ€™re only interested in data that exists in both the files, please use an โ€œInner Joinโ€ else go ahead with a โ€œLeft Outer Joinโ€.
After the join is applied, youโ€™ll have to still use a mapper to select which columns youโ€™re interested into.

Hope that helps!

Regards,
Darsh

Sharing some snaps, sample pipeline and files for your convenience:

image

image

Branches.xlsx (9.7 KB)
Branches_Managers.xlsx (9.1 KB)
Branches_Managers_2022_11_23.slp (12.7 KB)

Regards,
Darsh

SL12345
New Contributor III

that was helpful. thank you very much

marjan_karafilo
Contributor

Hi @SL12345 ,

As @darshthakkar said, you can use different snaps.

I have made a simple pipeline to achieve this, using Sort, Join and Mapper. Join is set to โ€œleft outerโ€.

Test pipeline_2022_11_23.slp (14.1 KB)

BR,
Marjan