tSortRow case insensitve

[Anonymous]

Hi,

How can we sort ignoring case of column in talend.

Thanks,

Suneel.

[akumar2301]

workwround : 

Create additional column before tsortrow in lower or upper case of orginal column , and sort on that. 

There is already a JIRA ticket to implement this feature but not not yet done

https://jira.talendforge.org/browse/TDI-5506 . 

[akumar2301]

workwround :

create a new column before tsort in lower/uppercase of original colulmn. and use that for sorting.

There is a JIRA ticket to implement this feature but no yet done.
https://jira.talendforge.org/browse/TDI-5506

[tjohn]

Hi Suneel, 

you can upcase  column then Sort

Thanks,

tjclearner

[Anonymous]

Is there any other possibility, because the data should not be changed.

Thanks,

Suneel.

[tjohn]

In a tmap : Add a new column col2 --- UPCASE of col1

Then in a tSortRow ---- sort by Col2

Thanks