Ignore a field when the value is not a serial number in a transform map

[Adam Wood]

Hi 

I have a issue where serial numbers are been overwritten by blank values when running a transform

e.g.

CI has serial number 'abc' 

Import Set has nothing in the serial number 

Transform runs

CI serial number is blank 

What is best way to Skip\Ignore the transform from overwriting the value. However, I still want the other fields to update and not to skip the full row. I don't think its an Empty field as I have the 'Copy empty fields' unticked. 

[Adam Wood]

Hi @Ankur Bawiskar 

I have done this and it has stopped overwriting the serial field with a blank value.

However, now when a serial number is present in the import set it does not update the serial number. 

The name of the filed on the import set is u_serialNumber. i updated your script to: 

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

// Add your code here

if(global.JSUtil.notNil(source.u_serialNumber)){

target.serial_number = source.u_serialNumber;

}

})(source, map, log, target);

Thank you 

Adam

[Ankur Bawiskar]

@Adam Wood 

Glad to know.

it should update actually.

Are you sure the serial number on target is not getting overriden with some other value because of some BR etc

[Adam Wood]

@Ankur Bawiskar 

There is nothing else interacting with the serial field

Thank you 

[Ankur Bawiskar]

@Adam Wood 

any update to this?