topic Re: Date sort with tSort. in Talend Studio

Date sort with tSort.

Anonymous — Mon, 23 Jun 2014 07:46:40 GMT

Hi.
I try to data sort with tSort, but it isn't worked that I expected.
sort Key is Date.
I expected output;
Date
--------------
2014-05-01
2014-05-02
2014-05-03
2014-05-04
2014-05-05
2014-05-06
2014-05-07
:
:
2014-05-30
2014-06-01
2014-06-02
2014-06-03
2014-06-04
2014-06-05
:
2014-06-26

I got result;
Date
--------------
2014-06-01
2014-06-02
2014-06-03
2014-06-04
2014-06-05
:
2014-06-26
2014-05-01
2014-05-02
2014-05-03
2014-05-04
2014-05-05
2014-05-06
2014-05-07
:
:
2014-05-30

How do I do?

I attach the setting image. now i have three sort key. other key works fine.

Thanks.

Re: Date sort with tSort.

Anonymous — Mon, 23 Jun 2014 08:03:31 GMT

Whether you are sorting date column ascending or descending? could not identify because the char is Chinese.
What is the default data type of date column inside metadata?
Vaibhav

Re: Date sort with tSort.

Anonymous — Mon, 23 Jun 2014 08:10:41 GMT

Hi Miki Kamijo,
If you want to sort the date column, first convert the column to string type then use tSortRow.
Then again convert the sorted column of string type to date.
Thanks,
Bhanu.