Saving files for input tool

[AbedAlzaghal]

I have many excel files that I use on daily basis in my workflow, and I am wondering  how can I save these files so I can insert them with an input tool directly. 

[Emil_Kos]

Hi,

I am not sure what you want to achieve. 

You want to have one input tool that will open many excel files at the same time?

If they are in the same folder you can just go with showing a specific folder using an input path and at the end you can write *.xlsx to input all excel files from this folder. 

[Qiu]

@AbedAlzaghal 

You mean batch input, if the Excel Files have same schema.

[AbedAlzaghal]

Hi Emil, 

sorry I didn't make my self clear, 

I want to insert excel files "through input tools " from saved connections button. 

As I use those files many times in different workflows. 

 So I want to access them in one click and insert them.

[atcodedog05]

Hi @AbedAlzaghal 

Have you tried copying the input tool and pasting it another workflow. When you are copy pasting if maintains the config too.

If you speaking about this option

Thats only db connections

Hope this helps 🙂

[Emil_Kos · Accepted solution]

Hi @AbedAlzaghal,

I have prepared two working solutions for you.

The first one is using directory tool. Overall it takes all the files from particular directory. I am adding a sheet name to the directory field using formula tool and afterwards I use dynamic input in order to take all the files and import them. Please bare in mind that this tool requires a template file as an example. 

The second example just takes a list that I have created and do the same thing. This solution will work better if the file have always the same names and they are in couple of different folders.

Both of those solutions will work if the input files have the same structure. 

I think the second option will fit your needs if those files are similar.