Forum Discussion

SL12345's avatar
SL12345
New Contributor III
3 years ago
Solved

Vlookup betwen two tables

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

4 Replies

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    3 years ago

    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