Import CSV data into servicenow tables row

dipa11
Tera Contributor

Hi all ,.

 

I have requirement to upload the list of user which contain name and email and user id so I want to upload this list into a table named as "u_grp_membership" which contain 5 rows named as Black user, dal user ,docu user, Salesforce user and power user so this 5 rows having column name which I have given above and another column name is grp membership in which we want to upload the data for particular docu user row 

 

So I am using import set for this first I am creating table then and load the  CSV file after that I am creating transform map and giving target table as u_grp_memership table so I am mapping the filed in mapping assist 

 

" Name from CSV file and grp membership field from target table after clicking on transform the data imported into table but I will create new entries for each user in grp membership column and I want that data to be in for particular doc user row so can someone suggest me any solution 

1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

HI @dipa11 

 

My video will help you to do this

 

https://youtu.be/6dU9yBQPq_I

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
ServiceNow #TechnoFuncational Disclaimer: These videos are from my training batch. These videos did not promote any ServiceNow Sales pitch or marketing. These videos are only for knowledge purposes & basic on my experience & Knowledge. Redistribution or copying of functionality is not allowed! ...