Create fields (columns) automatically while importing from CSV

[Alex153]

Hi guys,

I am trying to import CSV file with a lot of columns. Is there a way to create these columns automatically in my target table? I cannot see this option while creating transform map.

[OlaN]

Hi,

Short answer, no you can't.

The purpose of the transform is not to create or change the data model in the target table, it's just to put the right data/fields in the staging table into the target table.

The staging table on the other hand is more dynamic, and can/should be changed if the import file changes with added columns etc.

[Alex153]

Hi Olan,

Get it. Can I create then a new table automatically using fields from CSV file?

[Maik Skoddow]

Hi Alex

you can use the Easy Import feature and then after the first import you can modify automatically created configurations.

see https://docs.servicenow.com/bundle/rome-platform-administration/page/administer/import-sets/concept/...

Kind regards
Maik

[Alex153]

Hi Maik,

Looks like I have to create columns first (manually) and after import data