Permutation of columns during the import of CSV

0 votes
asked Dec 22, 2016 by anonymous

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 ?



Timothée Boulet


1 Answer

0 votes
answered Dec 22, 2016 by Adrien Lavoillotte

This probably means that you have duplicate column names. Those are merged, and it could use a warning here.