Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to combine 2 datasets

Dulleh
6 - Meteoroid

Hi All

 

I needed help combining 2 datasets

 

Data1,Data2,Data3

 

&

 

Header4,Header5,Header6
Data4,Data5,Data6

 

End result needed:

 

Data1,Data2,Data3
Header4,Header5,Header6
Data4,Data5,Data6

 

I have tried the Union tool and got the following results

 

Data1,Data2,Data3
,,,Data4,Data5,Data6

 

Any ideas?

4 REPLIES 4
Dulleh
6 - Meteoroid

Sorry to add the data is already in this way so i already created a workflow to show the data but unsure how to attach one file on top of the other

messi007
15 - Aurora
15 - Aurora

@Dulleh,

 

Have you tried to use a union tool and do the union by position

 

messi007_1-1641286021780.png

If you want to have the header of the second file to be part of the data, you can read it with header and then do the union :

 

messi007_2-1641286138521.png

 

Hope this helps!

Regards,

atcodedog05
22 - Nova
22 - Nova

Hi @Dulleh 

 

Union by Auto config by position. Refer the highlighted below

 

atcodedog05_0-1641286480441.png

 

Hope this helps : )

 

Dulleh
6 - Meteoroid

Wow, it was that easy! 🙂

 

Cant believe it i done everything correct just didnt select the "Auto Config by Position"

 

Working correclty now, Thanks a bunch @Messi

Labels
Top Solution Authors