Match and align columns from two tables

Hello I am new in Knime.
I have two tables and I need to match the columns and create column in table1 if they are missing in one table2 and vice versa. Please see attached.

Hope you can help me!

new.xlsx (11.5 KB)

Hello @paoerc and welcome to the KNIME Forum.

I have downloaded your board but I don’t understand what exactly your objective is, could you explain in more detail what you are trying to achieve?

To detect missing values you can use the node named Missing Values.

I look forward to your answer.

All the best,


Thank you @josegallardo for taking time to understand my question.

I am trying to align the column headers of two tables. (OLD 1 and OLD 2)
So at the end, two tables should have the same column headers. (NEW 1 and NEW 2)

All column names from Old Table 1&2 should be included to New Table1 and Table 2.

If Old Table 1 does not have the column names from Old Table 2, then that column name from Old Table 1 will be added to Table New 2 and put 0 on those values.

If Old Table 2 does not have the column names from Old Table 1, then that column name will be added to Old Table 2 and put on those values.

As for the sequence of the column names, my original column names are numbers.

so column 45,column 45, 55, 58, it is named like that. I just named it A,B,C, D to avoid confusion.
Hope you can help me :smiley:

maybe the table difference node could help you out.

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