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...
yashasvi74's avatar
yashasvi74
New Contributor
4 years ago
Copy LinkReport

Hi @Spiro_Taleski

On doing this I am getting error in Rest post snap. PFB the snapshot.

Regards,
Yashasvi

SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
4 years ago
Copy LinkReport

@yashasvi74

No, my proposal is to:

  • After File Reader Snap(if file that you are reading is xml) to add Document to Binary and then pass the content to REST Post Snap.

BR,
Spiro Taleski

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    4 years ago
    Copy LinkReport

    @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.