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

[binuacs]

@anas1 as @aatalai suggested use the batch macro for your use-case, you can put all your input files in a single folder and the batch macro will read the input files and combine them into one file. 

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[anas1]

Can you please provide an example with dynamic range? I've used it but getting error:  Error: Dynamic Input (5): No sheet specified, you must specify a sheet (I've selected a sheet in input data source template, reading as well field with the sheet name). Thank you in advance

[binuacs]

@anas1 you need to specify the sheet name as well with the file path