Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can we sort ignoring case of column in talend.
Thanks,
Suneel.
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 .
Hi Suneel,
you can upcase column then Sort
Thanks,
tjclearner
Is there any other possibility, because the data should not be changed.
Thanks,
Suneel.
In a tmap : Add a new column col2 --- UPCASE of col1
Then in a tSortRow ---- sort by Col2
Thanks