Clarification

[samsandy]

Hi All, i want to insert new column and MAP the certain data to that column by using vlookup. How to do that in Alteryx?

[DataNath]

Hey @samsandy, the way to do Vlookups in Alteryx is usually with a Join (though Find & Replace is a viable option, too). Here you can see I have 2 tables - Names & Amounts. I conduct the join based on the unique identifying field, in my case [ID] and the matching records will come out of the middle (J) anchor of the Join tool:

Hope this helps but let us know if not - workflow attached for you to check out.

Edit: In case you were curious, the Find & Replace method looks something like this, whereby you search for matches of the second table within the first, and append the extra field (Sales in my example) when a match is found: