Read data from multiple files based on index file (file containing file paths with inputs)

anas1

Hi all,

Looking for a way to read data from a source file containing inputs and outputs' file paths. 

Suppose you have a file name index.xlsx containing the following:

Input Path	Output Path
C:\Users\input1.xlsx	C:\Users\output1.xlsx
C:\Users\input2.xlsx

What I want the workflow to do is read the contents from both input paths and save the output at C:\Users\output1.xlsx

The reason for this is that my team keeps changing input paths and I want each time to update only index.xlsx prior to running the workflow.

Thanks all!

aatalai

@anas1 if they are the same schema, I would suggest trying the dynamic input otherwise, a batch macro could do the trick