Adding Multiple .csv files to a workflow

Good day,

I have a monthly report that requires me to take weekly data, which has columns containing staff names, and the dates in the month.

How can I add them from a directory into my workflow. I added them individually however would prefer an alternative.

Files are in .CSV

Appreciate any assistance.

Date Time

Accepted answers

Hi,

Please check this post. It will guide you how to achieve your goal:

Good Luck!

Use only one input data tool, and replace the filename part with the wildcard * (eg. C:\Users\directorypath\*.csv)

It will pull all the csv files in the directory, and union them all together.

Attempted it and used a marco however information, its coming out like below which causing issues further down.

The below shows how i have it using my original method.

Hey, no it didn't work, it unions them as you said but different schemas.