Union Tool Equivalent

Hi All, I’m trying to find a node that is similar to the Union tool in Alteryx.

My workflow is connected to separate datasets, one has a output of 96 column and the other 76 columns. I needed to union the columns that contain matching headers but also include the columns that do not as separate columns. I tried using the Concatenate node but it’s leaving out all the columns that do not have a matching header.

Am I missing something in the configuration or is there a better method to accomplish this? Would also be helpful if I can see which columns are being stacked and which ones are not.

Hi @Asimkz ,
which version of KNIME are you using? In 4.6, the concatenate node has the default option of “Use union of columns”. So maybe updating to the latest version will solve this issue.

1 Like