Transform maps - how to set *some* target fields to null when the source is null

[stevemac]

a seemingly basic question, but has defeated me so far

Importing data (from CSV) and transforming to the UNIX Server table

I have fields in the imported data that map to 2 choice fields, one string field and one reference field in the target

For these four fields only - when the source is empty / null I need the target field to be set to null.  Any other source fields that are null are not to overwrite the target

I cannot work out how to only do this for some fields

• Setting the Copy Empty Fields [copy_empty_fields] field to True on the transform map - sets it for all fields and I cannot get it to ignore some
• when Leaving the Copy Empty Fields [copy_empty_fields] field to False on the transform map - cannot get it to set a null value on the target record when using a sys_transform_entry with a script for the fields in question

I assume I can do this with an onAfter script, but was trying to avoid that

Any thoughts on how to proceed?

thanks,

Steve

[Inactive_Us1722]

Great! That is what I thought.

Having the script with only the fields we want should do the trick and of course the checkbox should be off.

Cheers,
Jefferson