Excel Sheet not being pulled in

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

May FY21 Metro FedEx Summary - FY21 (Sample).xlsx

Workflow

Accepted answers

Laurap1228

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

Dynamic Input Example.yxzp

All comments

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-multiple-excel-files/m-p/770774#M186902

charlenemx10

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

Laurap1228

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

Dynamic Input Example.yxzp

apathetichell

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

what happens in May doesn't stay in May.yxzp

charlenemx10

Thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703