i wnated to load data into incident form from excel sheet where in sheet priority has merged

SumeetC · ‎12-24-2024

i wnated to load data into incident form from excel sheet where in sheet priority has merged with state field

Dr Atul G- LNG · ‎12-24-2024

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]

****************************************************************************************************************

View solution in original post

Runjay Patel · ‎12-24-2024

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

-------------------------------------------------------------------------

View solution in original post

Juhi Poddar · ‎12-24-2024

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

View solution in original post

Dr Atul G- LNG · ‎12-24-2024

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]

****************************************************************************************************************

SumeetC · ‎12-26-2024

it should separate priority and state field, it should mapped to state and priority field respectively. This is the Business Case Here

Runjay Patel · ‎12-24-2024

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

-------------------------------------------------------------------------

SumeetC · ‎12-26-2024

it should separate priority and state field, it should mapped to state and priority field respectively in incident table/form.