Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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! ...