Hello
I tried to repeat steps in the vidoe, but I get the error:
https://community.alteryx.com/t5/Interactive-Lessons/Connecting-to-Multiple-Sheets-at-Once/ta-p/82874#done
Could anybody help me to solve the issue. I cannot understand why it does not work for me as I repeat exactly the same as in the first example.
Please see the attachments
Hi @ignas,
In the video, you'll see that when following the steps, if a sheet doesn't fit the template (the schema is different - fewer or more/different fields) then that sheet is skipped in the union. So you aren't doing anything wrong, it's just a limitation of that particular method. That is why I recommended installing the crew macros.
The other option is you can drag the file to your canvas and connect to each sheet individually and add a union tool after that.
@ignas, I apologize for a tardy response as I was away. I hope @john_miller9's explanation made sense to you. The schema has to be matching between the sheets. When we say schema, it's a fancy name for how the excel sheet/table is structured. A schema refers to the number of columns and the names of the columns themselves. If two sheets do not have the same number of fields and the fields are not named the same between the two, they will fail.
It's not working b/c the schema of the sheets is different. If you follow the directions on this post, you'll get the desired result.
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480
jm
Another option would be to download the CReW macros pack from Adam Riley's website (see below). The Wildcard XLSX Input tool easily accomplishes this.
http://www.chaosreignswithin.com/p/macros.html
Hey @john_miller9
Thank you for your quick response. Unfortunately I do not know what you mean that the schema of the sheets is different?
I took the first example from the video. Maybe you can tell me what it is exactly wrong?
The example that you sent is for files. The video example is for sheets. In the video they use only two Dynamic Input and Input data tools.
Thank you a lot for the help.
