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

[elsaaa]

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]

Hello,

You could use nested ternary operators.

condition?value if true:value if false

Here is an article about:https://community.talend.com/t5/Design-and-Development/tMap-expression-syntax/ta-p/21575

Best regards

Sabrina