Issues with Importing Excel file

Devlina

Hi everyone,

I'm currently uploading an Excel dataset into Dataiku. When I select "single datasheet," some Excel files are importing all of my columns correctly, but others are not.

Can anyone explain why this might be happening and suggest how I can fix it? I am looking for a dynamic solution using Python, so the input Excel file format needs to remain unchanged.

Thank you!

Turribeach

Post a sample Excel file you have trouble loading.

Devlina

https://community.dataiku.com/discussion/comment/45509#Comment_45509

so I have uploaded multiple excel and they are loading fine but for one few excel it causing this issue, even though they are in a same format.

Turribeach

https://community.dataiku.com/discussion/comment/45510#Comment_45510

Please post a sample of the Excel file that Dataiku is having trouble loading. You can anonymise the data if needed. We can't help you if we can't reproduce the issue.

Devlina

https://community.dataiku.com/discussion/comment/45511#Comment_45511

Hi,

Thanks, but after applying one empty prepare recipe the data seems to be working.

I couldn't share the file for the compliance issue.

Thanks.