Record limitation for multi file input

[grossal]

Hi everyone

I have some files with 10M+ records that I want to add to my workflow. I use the Input tool with *.xlsx to import all files with only one tool.

I know that the Input tool has an option to "Import only first N records", but this doesn't work across files. I want to import the first N rows of every file and not only the first N rows from the first file and none of the seconds and third file. What's the best way to achieve this?

Thanks in advance

Alex

[RolandSchubert · Accepted solution]

Hi Alex,

to create a list of files, you can use a Directory tool, but as the Dynamic Input tool has no option to limit the number of rows to read from each files, you'll have to create a macro and hand over a list of files, the sheet name to load and the number of rows. I've attached a small sample - what do you think?

Best,

Roland

[grossal]

This looks great, thanks a lot @RolandSchubert !