How to combine 2 datasets

[Dulleh]

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?

[Dulleh]

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 · Accepted solution]

@Dulleh,

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

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 :

Hope this helps!

Regards,

[atcodedog05]

Hi @Dulleh 

Union by Auto config by position. Refer the highlighted below

Hope this helps : )

[Dulleh]

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