nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Read a list of sheet names - error message: "XXX.xls|||AA has a different schema ..."

I have an input file - which has several sheets (for each country in APAC) and these sheets have the same column titles. I tried to input/read all these sheets of the same columns and the below error messages appear for 10 out of the 14 sheets:

Alteryx Error Message.jpg

I did a check and found that at least two columns are detected as different datatypes:

- V_WString vs V_String

- V_String vs Double

Is there a way to format all the columns of all the 14 sheets before I read/combine all of them together?

Thank you in advance!!

Error Message

Accepted answers

All comments

@syeap you need to use the batch macro instead of dynamic input tool for different schema error

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

Would you be able to teach me how to use this batch macro please? Thank you!

@syeap Attaching a sample workflow for your reference

Sample_Batch_220223.yxzp

Would you know why I have this error message? I tried to follow the sequencing as per your image.

Alteryx Error Message (1).jpg

@syeap The macro works for any number of worksheets. I think your input file path is not correct. Attaching the workflow and macro again. you can download the macro and insert it into the canvas.

Sample_Batch_220223.yxmd

Get_Sheets_Info.yxmc

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15911

MarqueeCrew 13710

apathetichell 13703