Zeros are being removed during Excel import

[e_wilber]

We have a simple transform set up to import some data and in one of the fields we noticed ServiceNow is tripping leading zeros off of our numbers.

The temporary transform field is set as a string and so is the resulting field on our table but SN is still converting 0001 to just 1 after it is transformed. How do I ensure we keep all of the 0s during the import?

[John Dahl]

When you say that the "The temporary transform field is set as a string" are you referring to the import set table? Make sure that the import set table field is a string.

Are any of the values single-digit? If so, did you try the "test with 20 rows" piece on the data source? I prefer not to use that because it will define the import set table based on those sample rows and it will NOT expand the fields if the real data has larger values. So if the sample has "1" then the field length may only be 1 character long.

Next, try changing the transform map field source from the source field to a script, then log what the transform is seeing coming from the import set table.