Problem with "Join" node

[Chris_88]

Hello everybody,

I have a problem. I would like to assign the country code from table 1 to the city in the “states” column of table 2 to obtain the following final table:

I used the node “join” to merge the two tables but I get a table containing empty cells.

Does anyone have an idea?

Thank you in advance,

Best regards,

Chris

[ipazin]

Hello @Chris_88,

although you can do it with Joiner node I would use Cell Replacer node which also has option to add found values to new column:

Cell Replacer

Br,
Ivan

[Chris_88]

Hi Ivan
Thank you, it works perfectly. The node “join” too. I had a space in the table that led to a mistake.
Thank you very much for your help.

Best regards,

Chris