Alphabets missing in serial number when data is importing from Data source

[Rahul Raja Sami]

HI

When asset data is importing from Data source (through attachment excel sheet) to Asset table for the serial number when added the alphabets are missing and only numbers are getting stored.

for example : if the data in Data source the Serial Number is GCMP8Y3 but data stored on the Asset table is 83.
why? but working fine in my PDI.

btw Serial Number on asset table is String type.

[Prabu Velayutha]

@Rahul Raja Sami There may be business rules, check if any BR for ALM Hardware table restricting string values, I'm not sure if this could be client script. 

If my response helped please mark it correct and helpful. 

[Rahul Raja Sami]

Hi @Prabu Velayutha 
no, there is no script of such kind

[Prabu Velayutha]

@Rahul Raja Sami On the data source if you load the data from excel then are you able to see the serial number column with full Serial number with all characters in the import set table of the data source? 

I have faced the similar issue with Serial number it was a SFTP data source 3years ago, root cause was while testing I use to open the file and then attach to the data source manually this was causing some issue with the Serial Number data then later I found if I load the file from source SFTP to the data source then the Serial number data was properly loaded in to the import set table. 

Opening and saving xl or CSV can potentially impact the data format so avoid open the source excel or CSV file and load it directly to data source.

Try to copy the content of the file to other file and test the data import to the import set and then run the transform.

If you have the correct serial number in the import set table then it could be transformation issue, you can try converting the source serial number value to a string and try the transform.

Please let me know if you have any more questions.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

[Ankur Bawiskar]

@Rahul Raja Sami 

any field map script or transform script is removing the characters?

Any before insert/update BR is doing that?

Is this happening when you manually create the record?