Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

CSV import not picking up headings

JLudwig
Level 2
CSV import not picking up headings
 

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

0 Kudos
2 Replies
AlexT
Dataiker
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

0 Kudos
JLudwig
Level 2
Author

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

0 Kudos

Labels

?
Labels (1)
A banner prompting to get Dataiku