Any way to import records using CSV or Excel into multiple (different) tables at the same time?

[Aki18]

Is there any way to import records using Import Set (CSV or Excel) into multiple (different) tables at the same time?

Of course I understand that I can use Import Set function to import records via CSV or Excel, however, I think Import Set (source Excel) can be imported into just one target table in ServiceNow.

What I would like to do is to import records into multiple (different) tables in ServiceNow via just one Excel, in accordance with some sorting rule in bulk. Is it possible?

If there are some best practices, please let me know.

Best Regards,

Aki

[HIROSHI SATOH]

You can import the data using an Import Set as usual, but instead of mapping everything directly to one table, you can create multiple Transform Maps, each targeting a different table. These Transform Maps can be configured with conditions to ensure that only the relevant records are processed for each table.

• Step-by-step process:
  1. Create an Import Set Data Source for your Excel or CSV.
  2. Create multiple Transform Maps, each mapping to different target tables.
  3. Use conditions within the Transform Maps to filter the data that should be inserted into each table.

[Aki18]

Hi @HIROSHI SATOH ,

Thank you for your advice.
Looks like we can use 'Robust Import Set Transformers' as well to transform the data as desired after importing via Excel or CSV and then load that data to one or more target tables.
https://docs.servicenow.com/bundle/xanadu-integrate-applications/page/administer/import-sets/concept...

[HIROSHI SATOH]

I answered based on my memory from the initial ServiceNow training, so I wasn't aware of robust-import-set-transformers. Thank you for letting me know.