Need to create incidents in the Incident table via transform map

[SAS21]

I have to generate 700 incidents via data load 

i have the below reference fields on the form and email ids are provided via excel

Requester,

Requesting on behalf,

Assigned to

Requester is a mandatory field , Requesting on behalf sometimes can be empty and Assigned to is mandatory 

 For all the above fields name is displayed on the form. 

how to generate incidents via import set transform map based on the email ids given from the excel

Thank you for the help

[Ankur Bawiskar]

@SAS21 

your excel doesn't have any INC number?

Is that what you expect in file?

If you always want to insert then remove that field map?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar · Accepted solution]

@SAS21 

If excel can have empty number field then ensure in your transform map check this checkbox

I assume you have configured the Number column

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Viraj Hudlikar]

Hello @SAS21 

You will use field mapping on reference field just give which field you will use to identify reference record. In below example we are mapping value from source table for column "created by" to target table column "caller" now while mapping we are checking with refernce field column as email if match found this entry happens else it get ignore if choice action selected is ignore if created option is selected it will create a new user entry on reference table.

Check this video for more details. https://youtu.be/UoadcmEG548?si=qr2dodETF8GPrd2m

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[Viraj Hudlikar]

Hello @SAS21 

Thank you for marking my response as helpful! 😊

I hope your concern has been fully addressed. If it resolves your issue, please consider marking it as the accepted solution. This will ensure others in the community can benefit from the solution too.

Thanks & Regards
Viraj Hudlikar.

[Dr Atul G- LNG]

Hi @SAS21 

What is required to generate the transactional data? You can do this by importing XML from another instance.