Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Union data set without sorting

aeolus187
8 - Asteroid

Hi Engineers,

 

How could we union data without sorting data?

for example i have data like

COL ACOL B 
AAACCC
BBBDDD

My expected result is 

COL ACOL B 
AAACCC
BBBDDD
AAACCC
BBBDDD
AAACCC
BBBDDD

 

 

4 REPLIES 4
fmvizcaino
17 - Castor
17 - Castor

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.

fmvizcaino_0-1645671614675.png

 

Best,

Fernando Vizcaino

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
amruthas2
8 - Asteroid

@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.

amruthas2_0-1645674287736.png

 

aeolus187
8 - Asteroid

@fmvizcaino @amruthas2 
thanks for the solution!!

Labels