In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How join tool in Alteryx sorts - in the backend - Join tool sort function

RSreeSurya
9 - Comet

Hi Team,

 

I have inputs from multiple input tables and after multiple joins I get the required output. When implementing same extraction and join using normal Alteryx tools and same logic in IN DB tools , the output is matching. But the order of output is not matching. As I am sampling the data in the later part this is highly impacting my results , and this is the main restriction I have using IN DB tools. Can anyone please guide me how to get the same sort order similar to Alteryx join tool so that I can add the same for IN DB logic , so my order will also be same. Thanks in advance. Any inputs are appreciated, this is very urgent requirement. 

2 REPLIES 2
apathetichell
19 - Altair

I don't really get this. The data is the data. It matches or it doesn't match. If you need a specific order and it's small - datastream out to canvas and use order by in the datastream out. if you need a specific order in your DB - add a rowid. You can sort on it after your join, use sample in-db and use the order by option there.

simonaubert_bd
13 - Pulsar

Hello @RSreeSurya 

"When implementing same extraction and join using normal Alteryx tools and same logic in IN DB tools , the output is matching. But the order of output is not matching. "

It's your backend database that will do the join and make the sort...  not the sql query send by Alteryx.On the other site, the in-memory join tool is totally at the hand of Alteryx.

If you want a sort tool, you can vote for this idea

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/In-Database-Sort-Tool/idi-p/13160

(By the way : if you're an in-db user, I would suggest to upvote all the ideas that can help you ;) https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/idb-p/product-ideas/label-name/categ... )

Best regards,

Simon

Simon

Labels
Top Solution Authors