Prefix not working for Import Set.

[Riri]

So here is my question on servicenow. Firstly I created a Custom table with Prefix as MOB which will lead to creation of new id with prefix as MOB (MOB001, MOB002). Now I did is IMPORT set where I imported data from excel sheet. There was also this id which didn't had prefix as MOB but a random number(12,13,14,16). But when I imported, it got the number from excel sheet and not the prefix(1,2,3,4 and not MOB1, MOB2) which I mentioned during custom table creation. What is the solution for this.

[Sainath N]

@Riri : Based on my understanding of your question, you are setting the number field on the custom table with the feed you are getting from the Excel sheet. It's auto-numbering system automatically increments the number. Could you try removing the mapping for this field? If this doesn't solve your issue, could you elaborate and provide some screenshots that help us answer better?

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

[Dr Atul G- LNG]

Hi @Riri 

Seems you are trying to map the Auto number of ServiceNow with the Excel number, and the same understanding by @Sainath N . Is the same or some other case. 

[Harish36]

Hello Riri

You can drop the number column from excel sheet for your import. You have already defined the prefix in your custom table configurations. try dropping the column from excel and import the same. I hope it helps.

Please mark my answer as helpful if it resolves your issue.
Thanks