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.