Permutation of columns during the import of CSV
UserBird
Dataiker, Alpha Tester Posts: 535 Dataiker
Hi,
I tried to upload a CSV file with 304 columns with the first line containing the columns headers
But I observed 2 issues after checking the option "Parse next line as column headers":
- There were only 289 columns
- Some columns were permutated
However, the CSV looked fine without this option checked...
Have you already met this problem ? How can I solve it ?
Regards,
Timothée Boulet
Sidetrade
I tried to upload a CSV file with 304 columns with the first line containing the columns headers
But I observed 2 issues after checking the option "Parse next line as column headers":
- There were only 289 columns
- Some columns were permutated
However, the CSV looked fine without this option checked...
Have you already met this problem ? How can I solve it ?
Regards,
Timothée Boulet
Sidetrade
Tagged:
Answers
-
Hello,
This probably means that you have duplicate column names. Those are merged, and it could use a warning here.