Input from file directory

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.

AAA.xlsx

Output.xlsx

Dynamic Processing

Accepted answers

grazitti_sapna

Hi @Gsiva3 , try this.

Another method.

All comments

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.

Input from file directory-GS.yxmd

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.

Error.PNG

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335