Combine sheet names with rows when read from directory

[Arwa_Albutainy2712]

I have folder in my desktop, contain multiple excel file, each one of these excel files contain multiple sheet, so I want alteryx to read from directory dynamically and combine in one table each sheet name with the exist rows in that sheet, so I know each row come from which sheet and from which file name

[binuacs]

@Arwa_Albutainy2712 use batch macro for your use case, the sample attached

[Arwa_Albutainy2712]

thank you for you respnose, but what if i need to add dynamic input so i can read from the directory dynamically

[binuacs]

@Arwa_Albutainy2712 Batch macro works similar to dynamic input tool, also batch macro allows more flexibility compared to dynamic input tool, if you want add dynamic input tool, just search the community you will find so many related posts