Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Looping in alteryx

Sahanawaz
5 - Atom

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 

 

2 REPLIES 2
caltang
17 - Castor
17 - Castor

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?

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
ChrisTX
15 - Aurora

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

Labels