Directory Tool through to output - need some help please

Question

Hi Community,

Need some help please i have Intercompany FC demand I need to validate, so I save the files to my One drive, i want Alteryx WF to gab the files using a directory tool and stack the files (data) into unique lines of data to allow me to pivot the data by Item or Site or month ( different ways to look at the data set.

Attaching samples of the data files, the (sample of what required File is 1 screen shot) is using say a single item to show how I'd like to see the data, also I'd like to replace any blank FC Qty values with a zero 0 Value.

Path I'd like directory logic to be able to read from would be similar to this

Can someone please assist here?

TIA

Karl

sample of what required.xlsx

Consolidated Intercompany 2022_10.xlsx

Consolidated Intercompany 2022_9.xlsx

Consolidated Intercompany 2022_8.xlsx

Consolidated Intercompany 2022_07.xlsx

gautiergodard · Answer

Hey @Karl_Spratt

Here is one way to import all of your excels and stack them on top of one another - just change the full path in the directory tool to point to the folder where the files are saved on your machine.

I've added a few steps to cleanse the data for you as well.

Hope this helps!

EXCELstack.yxzp