Dynamic Input limiting rows imported

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.

Screenshot (38).png

Help

Database Connection

Accepted answers

DataNath

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

All comments

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!

Dynamic input.yxmd

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!

CF_Disclosures.xlsx

CF_Disclosures.yxmd

binu_acs

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

CF_Disclosures.yxzp

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?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703