Records not inserted into target tables using robust transform map

Vinay2509
Tera Contributor

Hi Team,

 

I am following RTE process for importing data, staging table is inserting but records not inserting on target table, please help with trouble shoot.

 

We already cross verified field mappings and same looks fine. 

Importset state is completed.

and done reprocess/retransform as well.

 

Still unable to see records on target tables, please advise.

7 REPLIES 7

@Vinay2509 
Thank you for the response. 
Importing data from excel is temporary for us. We will have custom script going forward and I do not see option for custom script in integrationhub - import. Also, no option to map data to multiple target tables.

@Nikita28 

 

Check this link it may help you, we have done single source to multiple tables using Integration HUB Import.

 

Check your excel data and their format to avoid challenges while importing/loading

 

https://www.servicenow.com/community/employee-center-forum/integration-hub-etl-import-from-excel-she...

 

Hello Sir,

 

Data is not inserted but going in state processed