Can directory tool adjust import line?

[Arno_M]

Hello,

How do I get a directory tool to start pulling multiple files from line 5 of each sheet? In my current process, I drop multiple files and adjust the “Start Dat Import Line” to 5. Can the directory tool adjust the import line to 5 so I can union the sheets with the proper headers?

Thanks for looking!

 

[apathetichell]

Directory Tool doesn't import multiple excel files (or any other file type) it gives you information on the files in a directory. To import these files you have to use an input data tool in a batch macro - and that input data tool can be set to start import form a specific sheet at line 5.

[Arno_M]

Hello, Can you please provide an example of the batch macro? Could the Directory tool be used with a dynamic input to pull the files?

[apathetichell]

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-180-Thousand-File-Challenge/td-p/461356

use one of the batch macros in the solutions here. Ignore all non-xlsx types.