- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 12:40 AM
i wnated to load data into incident form from excel sheet where in sheet priority has merged with state field
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 05:45 AM
Hi @SumeetC
In SN state and property are 2 different fields so you can't load the concatenated value in SN. If you still want to do it, you need to create a new field, and then map that field with an excel heading only then you can upload or create a new field and then in SN put a logic to concatenate State and Priority and set the value in this new field.
What is your business case here?
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 05:56 AM
Hi @SumeetC ,
You need to work on excel and separate the state and priority value in two different column. then create data source and transform map to load in bulk. Make sure you will be putting backend value for priority and state. like for P1,P2,P3 respective value would be 1,2,3 and so on..
-------------------------------------------------------------------------
If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.
Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay
-------------------------------------------------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 09:36 AM
Hello @SumeetC
You can write transform script to separate the priority and state and then assign them to respective fields.
Here is the transform script:
if (source.Priority_State) {
var parts = source.Priority_State.split(' State:');
target.priority = parts[0].trim(); // Always set priority
if (parts[1]) target.state = parts[1].trim(); // Set state only if it exists
}Note: Update the field name as it is configured in your system. Now the priority and state is populated through script, there is no need to map these two fields.
Hope this helps!
"If you found my answer helpful, please like and mark it as an "accepted solution". It helps others find the solution more easily and supports the community!"
Thank You
Juhi Poddar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 05:45 AM
Hi @SumeetC
In SN state and property are 2 different fields so you can't load the concatenated value in SN. If you still want to do it, you need to create a new field, and then map that field with an excel heading only then you can upload or create a new field and then in SN put a logic to concatenate State and Priority and set the value in this new field.
What is your business case here?
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-26-2024 02:44 AM
it should separate priority and state field, it should mapped to state and priority field respectively. This is the Business Case Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2024 05:56 AM
Hi @SumeetC ,
You need to work on excel and separate the state and priority value in two different column. then create data source and transform map to load in bulk. Make sure you will be putting backend value for priority and state. like for P1,P2,P3 respective value would be 1,2,3 and so on..
-------------------------------------------------------------------------
If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.
Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay
-------------------------------------------------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-26-2024 03:03 AM
it should separate priority and state field, it should mapped to state and priority field respectively in incident table/form.
