Missing data uploaded through data source
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā03-03-2025 03:12 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā03-04-2025 03:58 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā03-03-2025 04:34 AM
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.
Ankur
⨠Certified Technical Architect || ⨠9x ServiceNow MVP || ⨠ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā03-03-2025 05:06 AM
Yes, its onComplete. Could you please tell me which scripts can include data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā03-03-2025 05:25 AM
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.
Ankur
⨠Certified Technical Architect || ⨠9x ServiceNow MVP || ⨠ServiceNow Community Leader