Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Stack two data sets keeping only common columns

davidmakovoz
7 - Meteor

I have two datasets. They share some columns and some columns are different. I'd like to stack them (appending rows of the second dataset to the rows of the first dataset) but only keeping the columns they have in common. I can stack them using the Union tool, but I couldn't find an option to 'stack only keeping the common columns'. 

Thanks

1 REPLY 1
TSP
8 - Asteroid

Capture.PNG

Hi Davidmakovoz.


There is the option to output only the common subset of fields from within the union tool.

 

Hope that helps.

 

Labels