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

[Victouf]

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

[atcodedog05 · Accepted solution]

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. 

[atcodedog05]

Hi @Victouf and @BrandonB 

My experience has been it sorts on the initial data order.

1. I have 10 random numbers

2. Using filter I am splitting into odds and even numbers.

3. After union in sort on the initial data order.

In your data I couldn't make out how its sorting maybe join tool is interfering with the initial sort order😅

Hope this helps : )

[Victouf]

I couldn't find out either and thought maybe someone else could  😂 Thanks a lot for your help !

[atcodedog05]

@Victouf 

Maybe the join tool is interfering with the initial sort order 😅

Happy to help : )

Cheers and have a nice day!