How to connect to columns with different data?

Hey everyone,

I have two tables and would like to combine two columns (one from each table) in one new column. The strings in the columns that I’d like to combine do not match . My idea was to combine the two columns so that the strings from the two different tables are written together in the new column. Is there a way to do so? The joiner node didn’t work as I wanted it to do. Both tables have the same RowIDs btw.

Hope you guys can help me with that.

Br

@Martin_23 you should join them and the use the column combiner or the string manipulation node or a Java simple snippet.

5 Likes

Oh man, I didn´t know that the column combiner node exists. Works perfectly, thanks a lot @mlauber71 !

Br

3 Likes

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