How can we create variable in service catalog using transform map importing data from excel ?

[sumeetkumardas]

I have a service catalog which uses almost more than 100 variables .Please guide how can we create these variable using transform map .

Please provide some reference which could dynamically populate the data without manually creating the variables .

[Inactive_Us1474]

Hi,

Create a transform map with target table as item_option_new and source would be your import set table which you need to create.

Creating New Transform Maps - ServiceNow Wiki

Thanks

Akhil

Hit Like/Helpful/Correct, if applicable.

[tanumoy]

item_option_new is the table which store all the variables of all the catalog item. You need to insert data into this table through transform map.

Import Sets - ServiceNow Wiki

Importing Data Using Import Sets - ServiceNow Wiki

Creating New Transform Maps - ServiceNow Wiki

Transform Map Scripts - ServiceNow Wiki

[tanumoy]

Hi Sumeet,

Let me know if you need any other assistance on this or please mark it as correct so that others with the same question in the future can find it quickly.

[sumeetkumardas]

Thanks Tanumoy ,

It would be helpful if u can share sample   transform scripts which were used while importing data from excel to table .