Lookup

[bsanthoshpk]

Hi All, I need a help for attached file. All I need is to lookup Item num from 2nd table to first table using code num as common joining column. Here when I lookup A003 it should look for 1st occurrence of A003 in 2nd table and bring respective item num. but should skip 2nd or any further occurrence. It shld be taken care that number of rows in 1st table should not be increased or duplicated while lookup is done since it has revenue info and any duplication will increase the overall revenue which will spoil the game. Note: To be simple it should work very similar to excel vlookup. Inner join doesn’t work in that way as it duplicates multiple occurrences of 2nd table thus revenue is duplicated in 1st table. Can somebody help me in this? Thanks in advance. ReplyForward

[atcodedog05 · Accepted solution]

Hi @bsanthoshpk 

You can use sample tool to keep only first entry in table 2 and find and replace to map.

Workflow:

Hope this helps : )

[bsanthoshpk]

Hi @atcodedog05 

Yes. thanks a lot 🙂