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

Excel sheet importer plugin

connoryork
Level 1
Excel sheet importer plugin

Hello, 

I have an excel file with multiple sheets that have the same schema. When I create a folder to upload the file and ultimately use the excel sheet importer, it is shifting the columns over one spot on the output. For instance, Jan-22 is no longer showing as a column header, but Feb-22 is now in it's place. The data underneath Feb-22 is actually the Jan-22 data. Not sure what the issue is here.

 

Thanks for the help!

0 Kudos
1 Reply
JordanB
Dataiker
Dataiker

Hi @connoryork,

Thanks for writing in! I tested the importer on my instance using the headers you mentioned and was not able to reproduce this issue on my instance (see attached gif). I’ve also attached an excel file with test data, if you would like to test it on your end, that might rule out issues with the plugin itself. 

If you can send a screenshot of your header data, that would be helpful as there may be a mismatch somewhere in the data.  Alternatively, if you feel comfortable sharing the dataset in question, you can do so privately by live- chatting us on the Dataiku website.

Best,

Jordan

0 Kudos