Update target with empty or Nulll value by transform?

[_zg_r T_rker]

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

[Jaspal Singh]

Hi Ozgur,

Link How can I empty the contents of a target field on an import? I have two fields on the target table ... should help.

[Dubz · Accepted solution]

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.

[_zg_r T_rker]

Yes, it is exactly what I need. But this property could be dangerous especially for LDAP import. I don't want all fields to be affected, so that best way seems to use "source field script" rather than direct mapping

Thanks

[rob_pastore]

Yes,

On the Transform Map you will see a check box called "Copy Empty Fields".

The only thing to keep in mind is this is not on the field level, it's for the whole transform.   So every field will have this behavior.

If you only want a select few to copy blanks, then you will have to use a script.