Transform Map error when trying to import string to string

[Glenn H]

I created a transform map to create new incidents in our system.  We use data policies to enforce mandatory fields.  One of these mandatory fields is Call Back Number.  Call back number is a string field.  When importing a number into this field, the transform mapping finishes with no errors.  Records are created and filled in properly. 

When importing with text in this field, such as NA, I am receiving this error: Data Policy Exception: The following fields are mandatory: Call back number.  When I disable the data policy, the values do not get imported and instead we are getting a blank field.

This is an excel import to the incident table.  I've tried changing the column types in excel to see if that does anything but it is no help.  I've verified call back number is listed as a string field.

Any thoughts on what I can do to troubleshoot this better?

[Dhananjay Pawar]

Hi,

Is there any transform map script in place to check that field? or is there anything other than ACL?On target table what type of field it is?

Thanks,

Dhananjay.

[Anurag Tripathi]

Hi,

In your field map you can use the script option to check if the source.field_name =='NA' then replace it with blank, else leave it as is.

-Anurag

[Sukraj Raikhraj · Accepted solution]

check field data type (dictionary) on the staging table. That's where  I would start (change it there),  They are several ways to address during conversion.

[Glenn H]

That's it.  Thank you!