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
Solved! Go to 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
This looks great, thanks a lot @RolandSchubert !