Connecting to multiple file in a folder

[AnkitKeswani]

Hi Everyone,

I have an issue relating to connecting to multiple files. So the scenario is suppose in a folder I have multiple files (as given below Payroll file 1 to 4).

Now I have a template (attached below), I need all these data of (Payroll 1 to 4) file in the template. 

The template has the same format as the rest of the input files.

Please can someone help.

[Emil_Kos · Accepted solution]

Hi,

If all the files are in the same folder you can just use *.xlsx to merge all the files at once and you will have it working. 

Please see my workflow attached for a configuration of the input file.