Hi,
I have a use case where I need to import data from an Excel file into a custom TEST table in ServiceNow. The table has the following fields:
- type
- name
- category
- subcategory
- description
My Excel file contains three sheets:
- TEST_1
- TEST_2
- TEST_3
Each sheet contains relevant test name and descriptions. I’ve created a single Data Source using this Excel file and want to import all data into the code table using one import set table and one Transform Map.
Requirement:
I want to set the type field in the target table dynamically based on the sheet name:
- If the data is from TEST_1, set type = "problem"
- If from TEST_2, set type = "task"
- If from TEST_3, set type = "incident"
How can I process excel with multiple sheet in one data source and based on sheet name how can i set type field in TEST table.
