topic TSORTROW - Null value picked up as max value when sorted desc in Talend Studio

TSORTROW - Null value picked up as max value when sorted desc

DEV4 — Sat, 16 Nov 2024 05:12:08 GMT

Hello All,

I have a scenario where Im sorting a date column where there are two rows of data in which one date value is null and the other has a date value in it. But when I do sort descending talend is picking up null as max value rather than the one which has date in it. Please help me how to handle this scenario.

Below is how my data looks like.

My expectation is the second row should be picked up when I do a sort desc on that column but instead null is being picked up.

Below is the job.

Please help me understand how to handle this scenario.

Thank You.

Re: TSORTROW - Null value picked up as max value when sorted desc

Anonymous — Tue, 23 Jul 2019 04:42:39 GMT

Hi,

The issue is because you are trying to sort a date column as "alpha". Could you please select "date" as the option for sorting and it will work fine.

Please refer the example below for my sample file.

Hope I answered your query 🙂 Please spare a second to mark the topic as resolved. Kudos will be a bonus!

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: TSORTROW - Null value picked up as max value when sorted desc

DEV4 — Tue, 23 Jul 2019 05:14:55 GMT

Thanks for the reply Nikhil.

I just changed the type to date but Im getting an error

tSortRow_1_SortOut Bad sort criteria: couldn't sort column "Appl_Submit_Date" as date.

Below is the screenshot of my data and talend job. Not sure where I went wrong. Please suggest. User is giving me the csv file and below is how it looks like.

Re: TSORTROW - Null value picked up as max value when sorted desc

DEV4 — Tue, 23 Jul 2019 06:04:29 GMT

I missed changing the date format in tmap to the format in file. I changed it and followed your solution and that worked. Thanks again.