Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Integration HUB ETL staging table having empty fields

pratiksha5
Mega Sage

I am trying to populate data with integration hub ETL class printer. 

 

I created one data source when I am loading the data cost is not getting populated in -prepare source data for mapping

 

 

 

I changed the data type from decimal to currency when I loaded the data in data source I can see the data in import set table. But in prepare source data for mapping it is not coming up. 

 

Please help 

 
 

 

 

12 REPLIES 12

@pratiksha5 

you are not using Transform map for this?

Can you not add transform script to it?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

We are loading data in CMDB. Integraion hub ETL is the ideal tool for that. It calls IRE by default. 

 

@pratiksha5 

I haven't worked on it.

But if you are having option to script then you need to use the above syntax to set the currency value.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader