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 

so what did you start with and where are you stuck?

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

[SAS21]

@Ankur Bawiskar  

hi here is the source file i am trying with but not working as expected. pls suggest

[Ankur Bawiskar]

@SAS21 

so what's not working?

Record is inserted but caller is not set or group is not set

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

[SAS21]

@Ankur Bawiskar  record is not inserted. here is the error