Using VLOOK UP in ALTERYX

[HULK]

Hi,

I have a Input file where there are certain trades for which I need to apply Vlook up to fetch details from RAM file and give me output in result file. Please help me to apply Vlook-up for the trades which has comments as CAM &  MDR (in last column). My objective is that I need to see the output as same as in Result file. Please help

Attaching the relevant files.

[Luke_C]

Hi @HULK Use a join tool and jone Trade ID & Trade Ref. Because you have duplicates in the input file, you may want to summarize first before joining to avoid a cross join. There are plenty of great resources linked above.

Give it a go and attach your workflow if it's not working - better than having your work done for you.