Is it possible to insert records in a sequential manner from excel?

[MaharshiC]

Hi,

I want to import data in a sequential manner from excel to my staging table and then my target table . I am doing the first import through a business rule which is adding records to my staging table and then through transform map to my target table but I dont see the records getting sequentially added as is in the excel? Did anyone else face this issue? Is there a fix for this?

Regards,

Maharshi

[Chaz · Accepted solution]

ServiceNow doesn't process them sequentially because it pulls each Excel row in as it's own record into your Import Set Table.
What you could do is create a "Row Count" column in your excel and map that to a field in your Import Set Table. Then, in your Transform Map just add an onBefore script that would map them by just querying the Import Set Table and ordering by the "Row Count" field.