Alteryx Designer Desktop Discussions

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

Append Two Data sets with different fields

TimD1
5 - Atom

Hi, 

 

I am sure there is a simple solution to this, but I am attempting to append two data sets with a mix of similar and different field headings. I simply want the 'different' fields to be added as per the example below. Is this possible at all?

 

Thanks in advance!!

 

Set A:

TimD1_0-1574781822890.png

Set B:

TimD1_1-1574781852847.png

 

The output I want - Set A+B:

 

TimD1_2-1574781892025.png

2 REPLIES 2
MichalM
Alteryx
Alteryx

@TimD1 

 

If you use the Union tool in its default setting - autoconfig by name - you will achieve what you need.

echuong1
Alteryx Alumni (Retired)

You can use the union tool to achieve this. It will essentially combine all fields and all records. Let me know if that works!

Labels