- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-10-2025 07:08 AM
Hi all,
I’m looking to import data from an Excel file into ServiceNow using transform maps. The goal is to conditionally route records to different target tables based on the value of a specific column.
For example, if a column in the Excel file contains the value "Texas", those records should be imported into Target Table B, with all other columns mapped accordingly. Records where the column value is not "Texas" should be imported into Target Table A, also with all other columns mapped.
Please let me know the best way to achieve this within a transform map configuration.
Thank you.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2025 09:16 AM
Thanks for your help. I was able to achieve this and make it all work by creating this action found here by and removing the ones I previously added.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-10-2025 07:37 AM
Hi @Snowman15
from a data architecture perspective, it makes no sense to two have two custom tables with nearly the same data. So why do you want to go that way?
Maik
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2025 04:32 AM - edited 06-11-2025 04:33 AM
@Maik Skoddow They won't have exactly same data, it will be different.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2025 02:11 AM - edited 07-09-2025 02:27 AM
I think you need to look into IntegrationHub ETL 🙂
A note IntegrationHub ETL is a free tool (and is NOT part of IntegrationHub suite)
There are several OOB functions to do exactly what you need.
PS: I just saw that it might not be for CDMB, sorry IH ETL is for importing into CMDB (and a few non cmdb tables)
