Union Tool : doesn't stack input #1 on top of input #2

Hi everybody,

Just out of curiosity, I used a Union Tool and I was expecting it to stack the data from input #1 on top of the data from input #2 and it's not the case.

It doesn't bother me at all since I can see the data has been added looking at the number of records. But still I was wondering why ?

Any idea ?

Best

Copy of Assembly Scrap Report.yxmd

Assembly Area Database.xlsx

Query Final por Tx 51 SCRAP Controller _ 1328289 _ 2218960.xlsx

Traduccion Scrap 15.06.21.xlsx

Datasets

Accepted answers

atcodedog05

Hi @Victouf

Union data generally get sorted on an ID column. If you want data to sorted in particular order ie #1 then #2 you can set the data order in the union tool.

Workflow:

Hope this helps : )

All comments

atcodedog05

Hi @Victouf

Union data generally get sorted on an ID column. If you want data to sorted in particular order ie #1 then #2 you can set the data order in the union tool.

Workflow:

Hope this helps : )

BrandonB

You might want to check the box to specify which dataset comes first:

Victouf

Thanks, I thought that by default it was doing that. Otherwise do you know which rules by default it uses to stack the data ?

BrandonB

Most of the time you are correct that it will stack the data based on the order that the tools were added. There are some scenarios, however, where due to the nature of the computations behind the scenes the sort order could be different. Therefore if you would like a guaranteed sort order I would recommend checking the box and specifying which input should be first/second/third/etc.