This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I really do appreciate you helping me to solve the issue. Could we just concentrate into the solution displayed in the video`? I know that there are other solutions which work, but I am just curious what I am doing wrong than shown in the vidoe? You can see the attached files.
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.
@JoeM doesn't your answer imply that the "Connecting to Multiple Sheets at Once" tutorial is incorrect? It actually claims/shows that any sheet deviating from the base schema will be dropped/not processed.