How join tool in Alteryx sorts - in the backend - Join tool sort function
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- In Database
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
