ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
16 - Nebula
16 - Nebula

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
Top Solution Authors