One Star

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.
1 REPLY
One Star

Re: Using a order by

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