Input from file directory

[Gsiva3]

Hi all,

I have a folder with 20 sub folders in it. In each sub folder I have a excel file with same name. Now I have took those excel files into the alteryx using Input file directory tool and dynamic input tool. Now what I want is, I want to generate a report by summarizing the content based on the sub folder name. Is there any possible to bring sub folders name as well as along with the data, so that I can differentiate the data based on the sub folders name? I have attached my sample input and my preferred output herewith. Please suggest me a method to this.

[grazitti_sapna]

Hi @Gsiva3, in order to provide the subfolder name what you can do is when selecting input data source template in dynamic input tool , try this configuration and set output file name as field selecting full path then a new column with the path will be displayed then you can apply the transformation using regex tool

Output-

I hope this helps.

Thanks.

[Gsiva3]

Hi @grazitti_sapna thanks for the reply!!!

When I am running the workflow in RegexOut1 column, only 3 is coming as data in all rows. I have attached the screenshot. Can you please help me with this.

[grazitti_sapna · Accepted solution]

Hi @Gsiva3 , try this.

Another method.

[Gsiva3]

Thank you @grazitti_sapna Got it!!!

[grazitti_sapna]

@Gsiva3 , You are most welcome.

Happy to help 🙂