Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

ArunAnnaldas1908
6 - Meteoroid

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.

 

IDRegion
2India
4Germany
5France
6US
7UK

 

 

IDPinCodeRegion
52345 
352312 
634634 
226234 
3236234 
426243 
536234 

 

 

Output: 

 

IDPinCodeRegion
52345France
352312 
634634US
226234India
3236234 
426243Germany
536234France

 

4 REPLIES 4
SPetrie
13 - Pulsar

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.

SPetrie_0-1679081780814.png

 

blitz45
8 - Asteroid

@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

blitz45_0-1679082096272.png

 

binuacs
20 - Arcturus

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

binuacs_0-1679082084382.png

 

RobertOdera
13 - Pulsar

Hi, @ArunAnnaldas1908 

 

Several options:

RobertOdera_0-1679171116907.png

 

Labels