Looping in alteryx

Question

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

ChrisTX · Answer

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

caltang · Answer

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?