Integration HUB ETL staging table having empty fields
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-21-2023 06:05 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2023 02:15 AM
you are not using Transform map for this?
Can you not add transform script to it?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2023 02:26 AM
We are loading data in CMDB. Integraion hub ETL is the ideal tool for that. It calls IRE by default.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2023 02:36 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader