Importing data from csv

[Kairavi Bajaj]

I have this use case where I need to import some data into servicenow. This dataset is used to assign Ids to employees based on their location. A particular location can have ids ranging from 1-9 and A-Z and there are say 15 such locations. Some of these ids are already assigned and others are available. I have imported this data using a csv file, the snippet of which is attached. Now in servicenow, when I assign one of the available ids, using a lookup reference to this table, all of the available ids for that particular location get assigned to the employee and multiple copies of the same record get created - each with a different id. 
Can someone explain why this must be happening and What is the solution?

 

[Community Alums]

Hi @Kairavi Bajaj ,

It depends on how you are running the transform maps.

Can you share how you have setup the transform maps.

[Ankur Bawiskar]

@Kairavi Bajaj 

Please share how your transform map, field maps are configured

which field is used for coalesce?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Kairavi Bajaj]

The transform map is a direct mapping of the fields, no script involved. No coalesce as well because values in each column have duplicates - the location, location code as well as the operator id.