Auto-update of a field when an excel is imported using Transform Map.

Ramya-Sree
Tera Contributor

‎03-15-2024 04:03 AM - edited ‎03-15-2024 04:19 AM

We need to Check if the user is found in the excel, then check for his subgroup from the excel. Using transform map when a data is being transformed to UID config table then check for the subgroup and update the Group manager field with the respective group manager that subgroups user has.

Did anyone have implemented such kind of things.

0 Helpfuls
  • 202 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

‎03-15-2024 04:28 AM

Hi @Ramya-Sree 

 

SN scripts will work if data is in SN, here you asking to check in Excel, which is not the case.

 

If you want you can write transform map script and do the check in SN.

*************************************************************************************************************
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]

****************************************************************************************************************
0 Helpfuls