Problem with "Join" node

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,


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:



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,


1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.