Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using a order by

Hello,
I do a jointure (inner join) with many table. Before doing a Tmap to do converting, I wish to sort my data flow by an "order by".I saw it exists a TSortRow but this one doesn't accept many input. How can I sort result data flow ? Indeed, I would like to implement an example like this one :
SELECT * FROM A, B where A.id=B.id order by A.name;
Do you know how to implement it ?

Thnx for your help.
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi,
your SQL does a join and a sort in one statement. You can sort your row with tSortRow after the tMap.
Will this work for you or is there any additional specialty?
Bye
Volker