We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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