Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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