Dynamic input to Directory tool

sbatra116

problem:

read files and subfiles from a folder. BUT don;t hardcode the values in Directory tool

Issue:

Folder & file name/path will be stored in spreadsheet

Folder Path	File Name
C:\Alteryx\test	Company*.xls
C:\Alteryx\test	bank.csv

get folder,file name --> input this to Directory tool --> read data --> process --> repeat for the second line

Output:

data from all the files together for each row

row 1 - output 1

row 2 - output 2

if the input data has 10 rows then 10 output files.

but if input data has 1 row then  only 1 output file.

IraWatt

@sbatra116 I think I understand what you want and it sounds like an iterative macro. At what point do you want to stop looping through directories? Is it just the file structure your after or do you want every file to be mashed into one? Do you need to read every sheet in each excel file?