topic Sort Rows - Nulls at the end in Talend Studio

Sort Rows - Nulls at the end

_AnonymousUser — Fri, 26 Oct 2012 14:06:17 GMT

Hi
Can anyone please tell me how to achieve below scenario? Need to sort the rows making sure that the nulls comes at the end.
Input
ID
98
99
null
100
null
36
Output
ID
100
99
98
36
null
null
Thank you.

Re: Sort Rows - Nulls at the end

Anonymous — Fri, 26 Oct 2012 20:09:53 GMT

Use the tSortRow component you can sort by num descending

Re: Sort Rows - Nulls at the end

_AnonymousUser — Tue, 30 Oct 2012 15:08:06 GMT

Hi,
Thank you for the reply.
We can use tSortRow to sort the data. But it does have provision to handle the null values.
Regards,
Sangi

Re: Sort Rows - Nulls at the end

_AnonymousUser — Tue, 30 Oct 2012 15:08:41 GMT

Hi,
Thank you for the reply.
We can use tSortRow to sort the data. But it does not have provision to handle the null values.
Regards,
Sangi

Re: Sort Rows - Nulls at the end

Anonymous — Tue, 30 Oct 2012 15:13:50 GMT

Hi
Convert null value to 0 (or an other number) before sorting them, and then convert 0 to null value after sorting.

Re: Sort Rows - Nulls at the end

_AnonymousUser — Tue, 30 Oct 2012 16:40:47 GMT

Hi
Thank you. Its a good workaround.
However, it will be good to include an option in sort component to handle the nulls.
-
Sangi