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
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.

 

Regards, Akash
If my response proves useful, please mark it "Accept as Solution" and "Helpful". This action benefits both the community and me.

HIROSHI SATOH
Mega Sage

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