Issues with Importing Excel file

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!
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,329 Neuron
Post a sample Excel file you have trouble loading.
-
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 Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,329 Neuron
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.
-
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.