Problem with Transform Map

[atul3]

Hi All,

I am trying to load the data in ServiceNow using Data Source. Initially, I am trying to load top 20 records in my target table.

Data Source run successfully and it loaded the records in the Source Table (Extends Table: Import Set Row). But when I am executing my transform map, records are not reflecting in the target table. Mapping has been done. But don't why it is not working.

If i am trying to do this activity by excel file import. It worked fine. Please suggest me something how to resolve this problem.

Thanks in Advance!

Regards,

Atul Chauhan

[atul3]

Thanks Santosh...but i wanna know one thing...if credentials/details are wrong then how did it fetch the data and load it in Source table? Or data source also plays some role in transforming the data?

[santoshsahoonis]

The image that you have posted shows Total = 0. That means there were no records.

You should also check the other related list named 'Import set rows' to see if it actually imported any data.

Again, when you finish an import, you can see a related link called 'Import logs' that also will show you if there was any error.

If you still   have issues, please share the type of data source you are using.

[atul3]

Yes there are records in Import Set Rows and it loaded top 20 but problem occurs when it comes to transforming the data from source table to target table.

I do have data in source table but transforming it through data source is the problem.

If I'm trying to do this activity by fetching all records from my actual source to an excel then loading it followed by transforming. Data comes in both the tables (source as well as target).

You may be right that something is wrong with Data Source that i need to figure out. Please share your thoughts.

Thanks,

Atul Chauhan

[jessica_robinso]

Hi Atul,

Unsure if you figured this one out, but just in case others are having the same problem - running a transform map on a "test load" doesn't work.   If you "Load All Records" and then run the transform map, it should work.

[Pritam3]

Thanks Jessica, yes it works when we load all records.