Excel Sheet not being pulled in

[charlenemx10]

Hello. I am trying to pulling in a series of sheets by Dynamic input. Everything works fine except for May tab. Alteryx keeps showing it has a different number of fields than the 1st file in the set and will be skipped. Can anyone help me figure out where is it different in May. All these tabs are from the same system and have the same format. 

Please see the attached file for details. - May tab.

Any help would be greatly appreciated! 

Thanks!

Charlene

[Qiu]

The error is caused by the different schema between sheets.

You will need this one.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Read-sheet-with-same-name-from-multipl...

[charlenemx10]

every sheet has the same schema. They are from the same system.

[Laurap1228 · Accepted solution]

Hi Charlene,

I think there is something different about the formatting of the titles on the May tab. 

I used the attached workflow, and the only way I got it to work for May was to copy the row headers (row 4) from a different tab and paste them into May.

Cheers,

Laura

[apathetichell]

@Qiuis correct some of your worksheets have 14 columns - others have 13 (May). June only has an  F1 column. See the attached.

[charlenemx10]

Thank you!