Populate the value in 2nd column based on value match in 1st column

[ArunAnnaldas1908]

Dear Team, 

I am new to Alteryx and would like to do a lookup of ID column and if it matches, then copy the value of Region into another column.

Could you please suggest or any help is highly appreciated here.

ID	Region
2	India
4	Germany
5	France
6	US
7	UK

ID	PinCode	Region
5	2345
3	52312
6	34634
2	26234
3	236234
4	26243
5	36234

Output: 

ID	PinCode	Region
5	2345	France
3	52312
6	34634	US
2	26234	India
3	236234
4	26243	Germany
5	36234	France

[SPetrie · Accepted solution]

Use a Join Tool to join the two lists on ID. Then use a union tool to grab the items from the PinCode list that dont match as well as the joined items. 

A record id tool and sort will keep them in original order.

[blitz45]

@ArunAnnaldas1908 you can use the Join tool and join it by the record id. Once it goes through, you can select the field you want to disable and you will have your output. Take a look at my example workflow attached.

Middle Join will look like this

[binuacs]

@ArunAnnaldas1908 One way of doing this with the find and replace tool

[RobertOdera]

Hi, @ArunAnnaldas1908 

Several options: