CSV import not picking up headings

Options
JLudwig
JLudwig Registered Posts: 5 ✭✭✭
in Using Dataiku

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:
· Share on FacebookShare on Twitter

Answers

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

    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

    · Share on FacebookShare on Twitter
  • JLudwig
    JLudwig Registered Posts: 5 ✭✭✭
    Options

    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

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…