topic Re: Enter a null value in postgresql for a timestamp field according to a condition in tMap in Talend Data Catalog

Enter a null value in postgresql for a timestamp field according to a condition in tMap

elsaaa — Sat, 16 Nov 2024 05:48:08 GMT

Hey all ,

I need help , my job is about mapping beetween a csv file and a postegresql table .

According to a condition, if the date is like 99999999, I must map this column as a null value i the database .

After excuting my job , the 99999999's date is mapping as '100007-06-07 00:00:00' ,so not null .

Anonymous — Tue, 04 Jun 2019 04:39:27 GMT

Hello,

You could use nested ternary operators.

condition?value if true:value if false

Best regards

Sabrina