Clarification

samsandy — Tue, 18 Oct 2022 08:35:49 GMT

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?

Re: Clarification

DataNath — Tue, 18 Oct 2022 08:49:58 GMT

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:

topic Clarification in Alteryx Machine Learning Discussions

Clarification

Re: Clarification