Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

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

Union In database

vishnusai0908
6 - Meteoroid

Is there any chance to select specific output order in Union In database.

 

Ex: I have two input database DB1 and DB2 when i am union in in-databse it is not in order

 

Requirement:  I Want DB2 first then DB1 as the result

Attached the screen

6 REPLIES 6
ShankerV
17 - Castor

Hi @vishnusai0908 

 

The screenshot is missing...

 

 

Many thanks

Shanker V

PanPP
Alteryx Alumni (Retired)

Hi @vishnusai0908 

 

If you are using the Union In-DB tool, the order in which you are connecting to the Union will matter.

 

I would recommend connecting the DB2 Input first followed by the DB1 Input.

 

 

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.

 

 

vishnusai0908
6 - Meteoroid

Attached the screenshot

ShankerV
17 - Castor

Hi @vishnusai0908 

 

I see the connection between 2 nodes of the filter tool.

 

So you want the False node which is #2 needs be prioritized then followed by True node.

 

Hence, please remove the connection, try connecting the False node first and try connecting the True node second.

 

This will resolve your issue.

 

Many thanks

Shanker V

vishnusai0908
6 - Meteoroid

@ShankerV : it is not working, the data is merging for me

vishnusai0908
6 - Meteoroid

Hi

@PanPP : It is not working, the data is merging, can you helps us with other solution

Labels
Top Solution Authors