Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
Top Solution Authors