Import set state test

Krunal Mankar
Tera Contributor

Hello Team,

When I am running Import set on loaded 20 records. data is not getting transformed as well as no error in transform history. 
As well as import set state is also changed to "Test".
"Coalesce" is already on on one field
Any suggestion what went wrong

KrunalMankar_0-1698408401543.png

1 ACCEPTED SOLUTION

Harish Bainsla
Kilo Patron
Kilo Patron

If your data is not getting transformed, and there are no errors in the transform history, there could be several reasons for this issue. Here are some common troubleshooting steps to help you identify and resolve the problem:

  1. Data Mapping: Check that your data mapping in the transform map is correctly configured. Ensure that the source fields in your import set match the target fields in the transform map. If they don't match, the data won't be correctly transformed.

  2. Field Coalesce: While you mentioned that you have "Coalesce" enabled on one field, it's important to ensure that the coalesce field is correctly specified and that it corresponds to a unique identifier for records. If the coalesce field doesn't uniquely identify existing records, it may not update the correct records during the transformation.

  3. Transform Script: Review any transform scripts associated with the transform map. Check if there are any conditions or logic in the scripts that might be preventing the transformation from occurring. Ensure that there are no syntax errors in the script.

  4. Transform Field Conditions: In the transform map, you can specify field conditions that control when a field is mapped. Verify that these conditions are not preventing the field from being mapped.

please check video and do step as per mention you will get to know where you did mistake

https://youtu.be/CJMHSyeNAAQ?si=qPfwW0iixJI2_P3F

View solution in original post

Hi Youtube Family, I am Ravi Gaurav. I am Expert in ServiceNow . Welcome to my youtube channel. Import set ServiceNow | Import data into ServiceNow | Coalesce,Mapping Assist and Transform Map In this video we will learn how to load data to servicenow and map it. ServiceNow Link :- ...
1 REPLY 1

Harish Bainsla
Kilo Patron
Kilo Patron

If your data is not getting transformed, and there are no errors in the transform history, there could be several reasons for this issue. Here are some common troubleshooting steps to help you identify and resolve the problem:

  1. Data Mapping: Check that your data mapping in the transform map is correctly configured. Ensure that the source fields in your import set match the target fields in the transform map. If they don't match, the data won't be correctly transformed.

  2. Field Coalesce: While you mentioned that you have "Coalesce" enabled on one field, it's important to ensure that the coalesce field is correctly specified and that it corresponds to a unique identifier for records. If the coalesce field doesn't uniquely identify existing records, it may not update the correct records during the transformation.

  3. Transform Script: Review any transform scripts associated with the transform map. Check if there are any conditions or logic in the scripts that might be preventing the transformation from occurring. Ensure that there are no syntax errors in the script.

  4. Transform Field Conditions: In the transform map, you can specify field conditions that control when a field is mapped. Verify that these conditions are not preventing the field from being mapped.

please check video and do step as per mention you will get to know where you did mistake

https://youtu.be/CJMHSyeNAAQ?si=qPfwW0iixJI2_P3F

Hi Youtube Family, I am Ravi Gaurav. I am Expert in ServiceNow . Welcome to my youtube channel. Import set ServiceNow | Import data into ServiceNow | Coalesce,Mapping Assist and Transform Map In this video we will learn how to load data to servicenow and map it. ServiceNow Link :- ...