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.

[Maik Skoddow]

Okay, now I got your point.

As @OlaN mentioned correctly, it is not possible to create automatically columns in the target table. Imagine everybody would be able to do that. It would end in a great chaos! The data model is the holy bible, and there are tons of configurations to be done carefully when adding new columns.

The only situation I could imagine such a requirement is initial creating of a table. Both kind of Studio applications allow creating a new application and the containing data table based on a given CSV/Excel file. Maybe that is an alternative for you.

Kind regards
Maik

[Alex153]

@Maik Skoddow 

thanks for reply. Can you please give more details regarding Studio? I worked with Studio but and I could create table but using script where I specified all columns but this is not my case.

[OlaN]

Hi,

You can read on about Studio on the Docs site

There is also a good TechNow video that covers some aspects, to get started.

It's hard to give a good/precise answer to such a generic question.