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

Mark Manders
Mega Patron

Please share your scripts, that makes it easier to tell you where it is going wrong.

Also: why not do this within the field mapping itself. Just transform it on the upload, instead of afterwards on the uploaded data (if source contains efgh, remove it). Some regex on the transform field map script should take care of this.


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

There is no data related to regex inn transform map script and scheduled job, do we have any other scripts to look after for?

 

I said that that could be a solution, instead of running scripts after the import is completed.


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

The load was completed earlier, now noticed the issue