Unable to change field type on an import set table

[HP8]

I'm not even sure if it is possible, but I am unable to change a field type from an integer to a string on an import set table. I know that on the source table it is already set to string but on the import set table it is defined as an integer and I am unable to change it. Is there any way possible?

[Mark Roethof · Accepted solution]

Hi there,

What you are experiencing is correct, switching from Integer to String is not possible.

What you could do, is to delete the field, and create it again with string as type. Obviously this would effect existing records if your table is already in use.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020-2022 ServiceNow Community MVP
2020-2022 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

[Ankur Bawiskar]

Hi,

Did you find the root cause why it took field type as integer?

Did you try creating a fresh import set table with the file you have and check the behavior?

Regards
Ankur