Using a order by

Anonymous — Sat, 16 Nov 2024 14:15:17 GMT

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.

Re: Using a order by

Anonymous — Fri, 22 Aug 2008 20:12:17 GMT

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

topic Using a order by in Talend Studio

Using a order by

Re: Using a order by