CSV import not picking up headings

JLudwig
JLudwig Registered Posts: 5 ✭✭✭

I have a CSV file with the following format:

WorldBankRaw.png

However, on import, I don't seem to be able to get the column names:

WorldBankDataiku.png

Any ideas?


Operating system used: Ubuntu 18.04

Tagged:

Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,212 Dataiker

    Hi @JLudwig
    ,

    You likely didn't have the parse next line as column header initially,

    Can you try going to the Schema tab, remove all columns, then click on the "Update Preview" button to reload the columns.

    Thanks

  • JLudwig
    JLudwig Registered Posts: 5 ✭✭✭

    You are correct, on initial import the next line as column headers was not checked. I was able to fix this by first previewing the import and setting the "Parse next line as column headers" prior to creation.

    I didn't get a chance to try deleting all the columns and "Update Preview" as this would have been too time consuming. I still think this is a bug

Setup Info
    Tags
      Help me…