topic Re: tSortRow case insensitve in Talend Studio

tSortRow case insensitve

Anonymous — Fri, 18 Jan 2019 11:58:00 GMT

Hi,

How can we sort ignoring case of column in talend.

Thanks,

Suneel.

Re: tSortRow case insensitve

akumar2301 — Fri, 18 Jan 2019 12:19:43 GMT

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 .

Re: tSortRow case insensitve

akumar2301 — Fri, 18 Jan 2019 12:50:34 GMT

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

Re: tSortRow case insensitve

tjohn — Fri, 18 Jan 2019 13:06:23 GMT

Hi Suneel,

you can upcase column then Sort

Thanks,

tjclearner

Re: tSortRow case insensitve

Anonymous — Fri, 18 Jan 2019 13:36:34 GMT

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

Thanks,

Suneel.

Re: tSortRow case insensitve

tjohn — Fri, 18 Jan 2019 21:29:01 GMT

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

Then in a tSortRow ---- sort by Col2

Thanks