Multiple xlsx Input Different Schema Error

sallyjeon124

Hi,

I have an Alteryx model that uses both xlsx and xls format. The workflow for xls works fine, but I am not sure why xlsx workflow gets different schema error. Could you please let me know how I can input multiple xlsx files? I have 100 xls and 80 xlsx that has same format (but different tab name, let's say xls tab name is tabA and xlsx tab name is tabB). I want xls and xlsx go through the same workflow and join the result at the end to give me one output.

The Workflow:

xlsx input setting

I tried to use the star symbol (*) to input the multiple files. I did work for the xls format, but didn't work for the xlsx. Output file name as field must be file name only to run the workflow. The xlsx file formats are exactly same.

The error I received:

AbhilashR

Ah yes, I remember the previous example. Assuming you are looking to consume multiple files in your previous solution, I merged the file read piece from today's post to the previous. Let us know if this solves the issue.

As for the ? error you saw, it typically happens when the base alteryx file (.yxmd extension) cannot find the corresponding macro file (.yxmc). In such cases, you can right click in the Designer canvas and insert the macro manually. The image below is an illustration of the steps.

Hope this helps.

excelReaderUpdated.zip