Update target with empty or Nulll value by transform?

_zg_r T_rker · ‎12-12-2017

Normally transform map doesn't update the target field with Null or empty value when the source field is empty or Null. I can use "source script" for Updating the target with Null when the source is Null. However I wonder whether there a simple property for it. In the mapping there are options like "Protection Policy", "Customer Update" or "Map" Could I use these options for Updating with Null value*

Regards,

í–zgür

Dubz · ‎12-12-2017

Hi Ozgur,

Is your requirement to update fields with the word 'Null' when an empty or NULL value is imported? I don't think there is a specific property to achieve that, the closest is probably 'copy empty fields' but that just copies empty fields and overwrites target fields. You could write an onBefore transform script to say, if the source is empty return 'null' though.

View solution in original post

Aditya Telideva · ‎12-12-2017

Also you may refer to How to clear out the field on target table via Web Service + Transform Map