Schema Issue

[amnahhussain02]

Hi all,

So my workflow finds all excel sheets in the directory

It then filters all filenames with 725 as these are only relevant to me

The macro:

Finds all sheet names of all folders within the directory as not all have the M3 Sheet I targeted.

Back to workflow:

Filters all files with sheet name M3

Creates a filepath for dynamic input to read.

This is where it gets complicated.

The workflow does its job but only scrapes the data of one file and stops because the schema differs.

I have compared the scraped file with one of the others and found the column widths to be different only.

How do I skip this error?

[davidskaife]

Hi @amnahhussain02 

I assume its erroring on the Dynamic Input tool? You'll need to replace that tool with another Batch Macro, refer to here for guidance and an example Macro - https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309 

[amnahhussain02]

I've used this article to create my macro that's added above. My macro is doing this. It's erroring on the dynamic input yes.

[davidskaife]

Then you'll need another Macro instead of the Dynamic Input

[NeoInfiniTech]

Hi @amnahhussain02, did you try this solution? It should work if you are using Alteryx Designer 2023.1 or higher.