Dynamic Input limiting rows imported

[mokawner]

Hi all,

I am trying to upload about 5 sheets from a .xlxs file. When I upload them and execute the workflow, it only extracts the first 1,086 rows from each sheet which is the same amount of rows that the smallest sheet has, so I feel like it is just limiting its import to match that. I can't quite figure out how to fix the issue.

The data in excel is in a query but when I removed that formatting it still gave me the same issue.

Any superstars out there that can help me?

Thanks, Matt.

[DataNath]

How is your dynamic input set up? And is the schema consistent throughout? The workflow attached is a dummy I've just set up, uses the sheet with the least entries (5) as the template and seems to work fine. Perhaps one of the configurations here is different from yours?

If not, let us know!

[mokawner]

My dynamic input tool was set up to modify the SQL, however, I changed it to see if I could just get it to run configured like the dummy you made. I am now getting an error that my schemas are differing...but I checked them and they are all the same. Thanks for the quick reply!

[binuacs]

@mokawner a batch macro should do the work for you. 

[mokawner]

Thank you so much @binuacs

Is there any way I can use this workflow but modify it so the sheet names appear in a new column?

[DataNath · Accepted solution]

@mokawner you can just stick a join on, joining on FileName. Deselect the second 'FileName' as it's just a duplicate.

[mokawner]

Ahhh I see, I was overthinking it! Thank you so much for your help @DataNath and @binuacs!