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]

Hi @sallyjeon124, can you give the attached solution a try and see if it works in your case? For .xls files, you will have to explicitly define the tab name in tool ID 18 (formula tool). The Directory tool identifies all excel files to be read into the workflow, and treats .xlsx and .xls files in different ways.

As for the error, we tend to get those errors if the file structure across all xlsx files are inconsistent. 

[sallyjeon124]

Unfortunately, my company's alteryx version is an older one, so can't open your file 😞

[AbhilashR]

Can you give the files included in the attached zip file a try? I have downgraded the files to be able to run in v.2018.2.

[sallyjeon124]

It still gives me an error. Do I need to update any macro (e.g. updating file path, tab name or name of the file?

I remember you built this example model for me. I attached the model you previously built.

Thank you very much for your help.

[AbhilashR · Accepted solution]

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.