Union data set without sorting

[aeolus187]

Hi Engineers,

How could we union data without sorting data?

for example i have data like

COL A	COL B
AAA	CCC
BBB	DDD

My expected result is 

COL A	COL B
AAA	CCC
BBB	DDD
AAA	CCC
BBB	DDD
AAA	CCC
BBB	DDD

[fmvizcaino · Accepted solution]

Hey @aeolus187 ,

In your union tool, you can set up the output order at the bottom.

This sorting happens when you are using the same dataset only, if you have two different datasets, that will not occur.

Best,

Fernando Vizcaino

[MarqueeCrew]

@aeolus187 

I think that you want to append fields.  

data output connects to an append fields T & S anchors. 

deselect target field B and deselect source field A. Allow for ALL appends.  

magic!

 Cheers,

 mark

[amruthas2 · Accepted solution]

@aeolus187  Create a union of all the table and use sort option for the table, which will help you in not sorting by the fields.

[aeolus187]

@fmvizcaino @amruthas2 
thanks for the solution!!