Importing values in a custom table

micky09 · ‎10-20-2022

Hi,

I have a requirement where I need to import the data from an excel to a custom table in excel I am getting value of 3 fields for example email, UserID, Asset ID in on field after transforming it i need to push these three fields in 3 different fields at Target table lets say UID, Email & AssetID How can I achieve this any help will be appreciated.

kamlesh kjmar · ‎10-20-2022

Hi @micky09 ,

1. Use load data module of servicenow. In that specify the table name of your import set, if it's already not available then create a new one by selection create new option and upload your excel file.

2. Select the proper sheet number and header number normally it's 1.

3. Submit the form, a new page will open with related link, create transform map. Click on that, it will opena a transform map page. Select your desctination table here. In your case its your custom table.

4. Save the form and in related list do the proper mapping of your fields. Mapping of your source field to target field.

Below the link on how to create transform map

https://developer.servicenow.com/dev.do#!/learn/learning-plans/quebec/new_to_servicenow/app_store_le...

5. Finally when above steps are complete. Click on transform related link and then transform.

NOte : While mapping make sure to use any unique field as coalace, else as many time you will run the import, that many records will create as duplicates.

Following all the above steps will help you transformning all your excel sheet daya in servicenow.

I Hope this helps.

Please mark this helpful if this helps and mark as correct if this solves your issue.

Regards,

Kamlesh

View solution in original post

Sulabh Garg · ‎10-20-2022

Hi Micky,

The target table is same as you have selected in the "transform maps", If yes then you can just define the field mappings and that should be it.

If its other target table, then you may need to define the "on after" transform script and create a script to transfer the fields to the target table using Gliderecord.

Hope it helps.

Please Mark ✅ Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg

micky09 · ‎10-20-2022

This part I understood thank you for the reply! Just wanted to check on if in source data as I said in excel lets say there is a column name short description, in that column it self I am value of 3 fields lets say SD, Priority & category all are comin in this field but in my target table I need to import it by segregating the values how can I achieve that?

Ahmmed Ali · ‎10-20-2022

Hello,

Please go through below learning on import set and transform map:

Load Data | ServiceNow Developers

Also below youtube videos will be helpful to understand the same:

IMPORT SET ServiceNow | Import DATA into ServiceNow | Coalesce,Mapping Assist and Transform Map - Yo...

https://www.youtube.com/watch?v=MZlqauVaAzg

https://www.youtube.com/watch?v=6gMGJkcxxlI

Thanks,

Ali

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

micky09 · ‎10-20-2022

This part I understood thank you for the reply! Just wanted to check on if in source data as I said in excel lets say there is a column name short description, in that column it self i am value of 3 fields lets say SD, Priority & category all are comin in this field but in my target table I need to import it by segregating the values how can i achieve that?