Batch Macro - Field Schema Error [urgent]

[m_hohaus]

Hi Team, 

I have a Batch Macro that reads multiple Excel sheets with basically the same structure, except for the fact that they have a different number of columns. This difference comes from each sheet representing a project and the numbers worked on it each week and the project having a different number of weeks.

What the batch macro does is to count the number of total weeks someone has worked (by counting nonnulls) and outputting this to a table that looks the same for each sheet (namely just with the name of the employee and the number of weeks). The "unioned" table with number of weeks for each employee I then want to use for some other analyses in the main workflow.

Now, despite me selecting "Auto Configure by Position" the Macro is still giving me a field schema error. Does anyone know why?

Thank you!

Maria

[OllieClarke · Accepted solution]

Hi @m_hohaus does it also error if you tick this box?

[m_hohaus]

Lifesaver! Thanks!!!!