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

[Jim Coyne · Accepted solution]

Did you try right in the Script field of the Table Transform Map itself:

[chadlockwood]

Hey Jim,

I know this was from a while ago, but wondering if you can explain why the transform map script works to set a target field to null/''/empty, and the field transform and transform scripts do not? 

[stevemac]

thanks.  

No - was trying to do it in the field mapping section.  Will try there 

[Santosh_Ksagar]

Hi,

So if you don't want copy empty check box, then try script in mapping of that particular field. Let me know if you need more help.

Thanks
Santosh