Only Update Target Field if Source Field is Not Null

  • 97Views
  • Last Post 18 August 2020
Jordan posted this 14 August 2020

Currently if you upload a CSV with a blank column it will attempt to nullify the target field even if that field already has data. Is there an option, expression or other solution to prevent NULLifying a target field?

Order By: Standard | Newest | Votes
Dmitriy Muzurov posted this 17 August 2020

Hello Jordan,

Thank you for submitting a ticket with us.

Unfortunately, it's not possible to prevent nullifying a target field. It would be required to pass the value to the target that this target already has. In fact, overwrite it with the same value. This is not possible.

Should you have any questions, do not hesitate to contact.

Jordan posted this 17 August 2020

Can an expression be written that uses a target field?

Dmitriy Muzurov posted this 18 August 2020

Dear Jordan,

Thank you for getting back to us.

An expression can check source fields but can't check the value in the target fields.

Feel free to contact us, should you have any questions.