Directory Tool through to output - need some help please

[Karl_Spratt]

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 

[gautiergodard]

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!