Is it possible to include a CSV file without header labels in an import set?

HIROSHI SATOH
Mega Sage

I have a project where I need to import a file that only contains data and does not have a label row. I get an error when I try to import it into the import set. Is it possible to import a CSV file without a header label?

2 REPLIES 2

Akash4
Kilo Sage

Hi Hiroshi,

I doubt even after importing without Header row, you will definitely need the column mappings (hopefully with a coalesce set). If you are aware of which data column belong to which target table field, then I would recommend creating a header row of your choice (worst case as A B C D column names) and the rest is as usual importing to staging table & creating mappings in transform map.

 

HIROSHI SATOH
Mega Sage

Is it possible to import it? If so, please advise how to do it.