Macro to iterate groups of files

lhoffmeyer

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

Test Workflow.yxmd

atcodedog05

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 : )