Refer to the list to derive the value

[yudai_shiraishi]

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

Best Regards

[DultonM · Accepted solution]

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 · Accepted solution]

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

[yudai_shiraishi]

thank you for your answer.

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