topic Re: Union In database in Alteryx Designer Desktop Discussions

Union In database

vishnusai0908 — Tue, 06 Dec 2022 08:56:37 GMT

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

Re: Union In database

ShankerV — Tue, 06 Dec 2022 09:01:20 GMT

Hi @vishnusai0908

The screenshot is missing...

Many thanks

Shanker V

Re: Union In database

PanPP — Tue, 06 Dec 2022 09:11:59 GMT

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.

Re: Union In database

vishnusai0908 — Tue, 06 Dec 2022 09:05:59 GMT

Attached the screenshot

Re: Union In database

ShankerV — Tue, 06 Dec 2022 09:11:42 GMT

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

Re: Union In database

vishnusai0908 — Tue, 06 Dec 2022 09:31:24 GMT

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

Re: Union In database

vishnusai0908 — Tue, 06 Dec 2022 10:09:14 GMT

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