Combine sheet names with rows when read from directory

Question

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

binu_acs · Answer

@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

Arwa_Albutainy2712 · Answer

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

binu_acs · Answer

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

Combine_Sheets_040224.yxzp