Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multiple xlsx Input Different Schema Error

sallyjeon124
7 - Meteor

 

 

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:

 

input3.png

 

 

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.

 

input 2.png

 

 

The error I received:

 

input 1.png

5 REPLIES 5
AbhilashR
15 - Aurora
15 - Aurora

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.

AbhilashR_0-1586409419862.png

 

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

sallyjeon124
7 - Meteor

 

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

AbhilashR
15 - Aurora
15 - Aurora

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
7 - Meteor

 

 

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?

1.JPG

 

 

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

Thank you very much for your help.

 

AbhilashR
15 - Aurora
15 - Aurora

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.

AbhilashR_0-1586452261151.png

Hope this helps.

 

Labels
Top Solution Authors