Missing data uploaded through data source

KiranmaiP
Tera Contributor

Hi 
I have a data source, which I have uploaded into instance using load data and ran a transform map and then data has been uploaded, There is also a schedule job to run after transform map. where if the data in the excel sheet has abcd <efgh> ijkl\ mnop, If example, then after uploading to instance the data visible is abcd ijkl\mnop. Where data enclosed in <efgh> is  skipped in all parts of excel. How to overcome this issue and where to make changes ? There is also a schedule job to run after transmap. In what parts of script, does this occuring and what configuration to modify?Please suggest

8 REPLIES 8

So you want to correct data that is already imported? That's a complete different question. Just run the correction script on the data.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Ankur Bawiskar
Tera Patron
Tera Patron

@KiranmaiP 

did you check the import set status and see how many records got inserted/ignored/updated etc?

where is that job written? Is that in onComplete transform script?

Are you sure no error came when the job ran?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Yes, its onComplete. Could you please tell me which scripts can include data?

 

@KiranmaiP 

you will have to search in transform map how it's getting skipped.

we don't know what's configured in your instance.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader