Importset multiple tables

[maryc]

Hi,

I have a XLS file which has to be imported into SNOW. Can the importset be used to map fields into multiple ServiceNow tables   and run the transform map?

If not , what is the best approach?

Thanks

[tony_barratt]

Hi Mary,

You can define a transform map per target table.

Will that achieve what you want to do?

Best Regards

Tony

[venkatiyer1 · Accepted solution]

Hi Mary,

You can run two transform maps in an order suited to transform the data to two different tables. You staging table that is your source table will hold the data from data source. Then you can apply two transform and use two different target tables. You would have to create a field map to transform the specific columns for that particular table.

So your source table remains the same and target table differs.

[maryc]

I will try it out. Thank you for your help.