Loop through files listed in excel file and process each file

sforsandeep

I am trying to create a workflow which has an input file(xls) in which it contains many rows of data but fixed 3 columns

FilePath, TableName, Required

Filepath :- is actually an excel file path which is actually a report with many rows and columns

Table Name: SQL Table Name

Required: Boolean value 1 or 0

What I wants to accomplish is to loop through the file list and extract the report file name in each row and feed that filename to a dynamic input tool and then output the content into an SQL table(If not exists create that table). The SQL table name is the second column value. 

Also required column is something tells to process that row or not...

Please suggest a good way.. I am stucked.😥

phoebe_kelley

Good morning! I believe you could use the filepath in the dynamic input tool and then the SQL table in the output tool (check the box at the bottom to use a field as filename). If the excel files you are importing have different schemas, you could use a batch macro with a control parameter to go through each line in your initial data one at a time. The data going into the control parameter would be the filepath. The macro input would be your initial data: