Data Import Problem - Processed: 0, inserts 0, updates 0, errors 0, empty and ignored 100,

[OluseyiS3924078]

I am testing a Transform map that i am unable to get working the way i want. I am working with a Subset of the real data - 100 records.   I have verified that my mappings are correct, i even added an additional field mapping to populate the updated field using  a script just to update the records, however it skips all the records.  with a 'no values changed' comment

[TausifAhmedS]

Hi @OluseyiS3924078 ,

The transform map is working as designed.

Since Coalesce is enabled, ServiceNow first checks whether a matching record already exists in the target table. If a match is found, it switches to update mode and compares the mapped field values. If all mapped field values in the incoming record are identical to the existing record, ServiceNow does not perform an update. Because no values have changed, the system marks the row as “Empty/Ignored” with the comment “No field values changed.”

Please review the Coalesce configuration and confirm that it aligns with your requirement. In the Field Maps Related List you can find it of the current transform map record.

If updates are required even when the data is identical, you can consider one of the following approaches:

• Add a scripted field mapping to update a field (for example, a timestamp field) to force a change.

• Disable Coalesce (not recommended if duplicate prevention is required).

• Modify the source data so that at least one mapped field value differs.

If you find my answer helpful, please mark it as helpful👍 and accept solution✅.

Regard,

Tausif.

[Aditya_hublikar]

Hello @OluseyiS3924078 ,

Which script you tried in transform map ? Normally this behaviour happened due to Coalesce  field true . It will check is there any previous record same as inserting one by comparing Coalesce field .

Can please more elaborate about your code ? This will help to understand what actually happening .

If this helps you then mark it as helpful and accept as solution.

regards,

Aditya,

Technical Consultant

[Ankur Bawiskar]

@OluseyiS3924078 

unless you share config screenshots we can't help