In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities
here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started.
Learn more here
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hi @Ikader ,
you could use the SQL function RANK to do IN-DB ranking. A SQL query would be similar to this (use the MS SQL Server WorldWideImporters sample database):
The Rank function returns the rank of a record, it's completely done on the database server and you only have to stream out the results.
If you explain in more detail, what you need, I can be more specific.
Best,
Roland
