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

Rahul Raja Sami
Tera Guru

‎08-08-2023 01:40 PM

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 GCMP8Y5 but data stored on the Asset table is 85.
why? but working fine in my PDI.

RahulRajaSami_0-1691527226829.png

 

 

btw Serial Number on asset table is String type.

0 Helpfuls
  • 321 Views
2 REPLIES 2

Tushar
Kilo Sage
Kilo Sage

‎08-08-2023 05:26 PM

Hi @Rahul Raja Sami 

 

  1. Double-check the data type of the field where you are storing the serial number in the Asset table

  2. If it's set to a numeric data type, it could cause the alphabetic characters to be truncated. Make sure the data type of the field is appropriate to store alphanumeric values.

  3. During the import process, the data might be getting formatted or transformed in a way that removes non-numeric characters.

  4. Check if any data formatting or transformation steps are applied during the import, and ensure that they are not inadvertently removing the alphabetic characters.

 

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Regards,
Tushar

0 Helpfuls

Rahul Raja Sami
Tera Guru
In response to Tushar

‎08-10-2023 10:17 AM

Hi Tushar,

The field type is String and there is no script to filter the Serial Number.

0 Helpfuls