Directory Tool through to output - need some help please

Karl_Spratt — Tue, 08 Nov 2022 11:05:55 GMT

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

Re: Directory Tool through to output - need some help please

gautiergodard — Wed, 09 Nov 2022 13:40:01 GMT

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!

topic Re: Directory Tool through to output - need some help please in General Discussions

Directory Tool through to output - need some help please

Re: Directory Tool through to output - need some help please