Fill Excel sheet values in the RITM variables

[Gowtham Kodali]

Hi,

I have a requirement like 

I have to create Requests in ritm table and the Excel sheet contains the values which are to be inserted into the RITM variables . is it possible to Insert the  values from the Excel sheet to the RITM variables

and also the Username is given in the Excel sheet and I have to match that User name to the Requested for

Thank you

[Yash Agrawal1]

Hello Gautham,

Yes, you can import values from excel to ServiceNow nor staging table first, and from there you can use transform map  to map the field of the staging table fields (where you imported data from excel to ServiceNow table) with the target table field.()requested item in your case.

So will you please share more details of your issue.

so that i can help you step by step to get data into ServiceNow table from excel.

Please Mark it helpful/correct if my answer helps in any way to resolve your query.
Reach out to me if any more help required.

Regards

Yash.K.Agrawal

[Gowtham Kodali]

I need to import the Data into the sc_req_item table ;

I have an excel in that  values are given when importing the Data into the sc_req_item the values in the excel sheet should be populated at the variables in the ritm 

and the Username in the excel sheet should be populated at the requested for field

[Yash Agrawal1]

Hello Gautham,

Will, you share anyone record from your excel file.

Regards

Yash Agrawal

[Gowtham Kodali]