cancel
Showing results for 
Search instead for 
Did you mean: 

Refer to the list to derive the value

SOLVED
Highlighted

I want to guide the value of Group in List A by referring to List B

 

In IF statements using Formula, it takes time and it becomes difficult to modify.

Please tell me if there is the smartest and easiest way

 

 


List.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards

DultonM
Bolide

Hi @yudai_shiraishi,

 

When you want to combine 2 datasets into 1, you'll most likely be using the Join tool. Simply connect ListA to the L input anchor of the Join tool and ListB to the R input anchor. In the Join tool's configuration window, choose "City" from the Left drop down under "Join by Specific Fields". Lastly, run the workflow. The result you want should appear in the J output.

gnans19
Alteryx Certified Partner

Also you could use "Find Replace" for one to one match.

thank you for your answer.

I did not notice simple things.
Thank you for your help