Hi,
I am trying to create a loop where I have multiple files in a folder and same action needs to be performed for each file in the folder. I am not able to select folder as input. the process involves a comprehensive sheet which has multiple unique ids in column A. The process splits the comprehensive file into multiple workbooks in a predefined path for each unique Id. For example if I have 10 unique Ids in column A. the process splits the comprehensive file and creates 10 different workbooks in predefined path.
Can someone suggest how can I enable a loop functionality
Thank you
What you’re looking for sounds like a Batch Macro. But for more details, can you provide some sample data and sample outputs so that we can better understand and guide you?
Loop functionality is implemented by Batch macros and/or Iterative macros.
You can find video training for macros here:
https://community.alteryx.com/t5/Videos/bd-p/live-training
https://community.alteryx.com/t5/Videos/Video-Training-Index/td-p/45161
Chris