Alteryx Designer Desktop Discussions

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

Macro to iterate groups of files

lhoffmeyer
6 - Meteoroid

Hello,

I have a workflow that filters a set of files in a directory by country and runs a process for a "pre" file and a process for a "post" file.

I am trying to figure out how to add an iterative macro to this workflow so that it processes each country (two files each) rather than

having to use filters for each country.  I have little experience with macros so I am not sure of the starting point for the macro.

I imagine someone with macro exp. will have the solution in a flash.

France and Germany would also get processed.  I didn't add their processing for brevity.

In the actual workflow I am processing XL files and not text fields so I would use the "FullPath" field to open the file.

 

TIA,

LCH

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @lhoffmeyer 

 

What you need is a batch macro https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923

 

Since your requirement is not very I wouldn't be able to help you much.

 

Hope this helps : )

Labels