Directory Tool - Several Excel Files from one folder

[julianhoetzel]

Hi, 

how can I automate the process of pulling several Excel files from one folder into one workflow with the following criteria:

Name of Excel file is always

2021-01-01_ABC

2021-01-02_DEF

2021-01-03_GHI

...etc.

The columns of the associated Excel files always follow the same structure:,

Customer	Quantity	Amount	Customer	Quantity	Amount
XY	2	10	WZ	12	2547
XY	23	132	WZ	1	232
XY	1	23	WZ	2	52

The output should look like this:

Date	Quantity XY	Amount XY	Quantity WZ	Amount WZ
2021-01-01	2	10	12	2547
2021-01-02	23	132	1	232
2021-01-03	1	23	2	52
...usw.

By using the Discovery Tool I should automatically pull the files from the folder (see "FileName"). However, I cannot proceed afterwards (or I am probably too stupid to do so)...

Thanks for your help 🙂 

 

Best

Julian

[JosephSerpis · Accepted solution]

Hi @julianhoetzel you might want to look at this guide it should help you with your workflow.

[afv2688 · Accepted solution]

Hello @julianhoetzel ,

How about this?

Regards