Hi all!
I am quite new using Knime and I am not used to all its functions yet. I am looking for a way to concatenate two columns (Col_A and Col_C) from two tables (table 1 and 2) into another table (Table 3), by addying the missing values in the new table as a -, this way:
Table1 Table 2 --> Table 3
COL_A COL_B COL_C COL_A&C COL_B
2 145 1 1 -
4 834 3 2 145
6 567 5 3 -
4 834
5 -
6 567
Is there a way to do this using the nodes? My real data is based on two tables that have to be join by chronological time. Thanks a lot for the help! =)
Ele