Five Stars

Date sort with tSort.

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.
2 REPLIES
Four Stars

Re: Date sort with tSort.

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
Two Stars

Re: Date sort with tSort.

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.