Input error

[aparna0208]

Hi,

I came across a new error and I have no clue as to what it is. I'm inputting an excel file. Any help on this please? Thank you in advance!

[DavidP]

I think what's happening is that you're trying to load an excel file as a yxdb file format. Check option 2 in the input data tool configuration pane

[grazitti_sapna]

Hi @aparna0208 , in case your configuration file is different than the screenshot attached kindly change the file format to xlsx or simply drag and drop the file into the canvas.I believe you are trying to input xlsx file but using a different file format. I hope this works.

Thanks.

[aparna0208]

Thanks for your inputs @DavidP @grazitti_sapna . This is kind of weird where when I plug in another excel file then workflow runs fine but for this one particular excel file it throws error. Also, the error is somewhere in the middle of the workflow. As indicated in below screenshot, the purple arrow is where I plug in the excel file but error occurs in the tool indicated in red. I'm confused as to why it would error out only for this particular excel file.

[DavidP · Accepted solution]

All the error means is that the filename and filepath points to an excel file (which is correct), but just underneath that where the file format is specified, the yxdb format is picked, so all you have to do is change the file format from yxdb to Excel in the tool that has the error.

I have replicated this and showed a screenshot in my original post to show which bit has to be changed.