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...
  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    4 years ago
    Copy Link

    @karthik_dhina: The solution has been provided by @bojanvelevski - trust me it works. If at all you do not want to use a mapper then you can always leverage some snaps like filter and router for the same but you’ll have to use a mapper after the results are filtered and assign the default value.

    Alternatively, you can also use Conditional snap to achieve similar use cases.