Excel sheet importer plugin

Options
connoryork
connoryork Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 1 ✭✭✭
in Plugins & Extending Dataiku

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!

Tagged:
· Share on FacebookShare on Twitter

Answers

  • JordanB
    JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 293 Dataiker
    Options

    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

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…