Forum Discussion

karthik_dhina's avatar
karthik_dhina
New Contributor
4 years ago

Mapper - change value in target path based on condition

I have the below req. i want to update the value of a column only if it’s null else leave as it is. ex: raw_table.date_joined will be populated only if it’s null, if it’s already have a value lea...
mapper
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

Hi @karthik_dhina,

You can do this by using the ternary operator. Check this out:

$date == null ? Date.now() : $date

This translated means, get me the ‘date’ field, but if it’s null, than get the current datetime. If you want to add current datetime even if the field doesn’t exist, than try the following:

$.get('date') == null ? Date.now() : $date

BR,
Bojan