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

Question

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.

simonaubert_bd · Answer

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/category%20in%20database )

Best regards,

Simon

apathetichell · Answer

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.