Hi @Rajan734 ,
To load data from a data source into a staging table, use the All menu to open System Import Sets > Load Data. The configuration options vary depending on the Data Source. In the example, the Data Source is an Excel file. The staging table, u_occasions_staging, is created dynamically.
Click the Submit button to load the data from the Excel file into the staging table.
After the records are imported into the staging table, a Progress page appears.
Once data is loaded, click the Create transform map link in the Next steps... section to map data from the staging table to the target table.
Also, follow this blog to understand with a use case : https://www.servicenow.com/community/developer-blog/data-load-and-transform-via-catalog-item/ba-p/22...
Hi @Rajan734 ,
To load data from a data source into a staging table, use the All menu to open System Import Sets > Load Data. The configuration options vary depending on the Data Source. In the example, the Data Source is an Excel file. The staging table, u_occasions_staging, is created dynamically.
Click the Submit button to load the data from the Excel file into the staging table.
After the records are imported into the staging table, a Progress page appears.
Once data is loaded, click the Create transform map link in the Next steps... section to map data from the staging table to the target table.
Also, follow this blog to understand with a use case : https://www.servicenow.com/community/developer-blog/data-load-and-transform-via-catalog-item/ba-p/22...
