Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Create a Filter Macro or Split Report Macro

Highlighted
5 - Atom

I'm trying to create a filter macro for a report that we use for over 50 locations and over 5k lines that would allow me to filter by entering the name or from a dropdown. Or even if possible, would split the file into separate files based on the filtered name. 

 

This is as far as I got and now I'm stuck

katonyaj_0-1585236312221.png

 

I have attached a sample report and my attempt at this macro. 

 

Any advice would be great!

 

 

 

 

Highlighted
11 - Bolide
11 - Bolide

splitting the file is pretty straight forward:

at the bottom of the config window, there is an option to split the output file from a field.

jarrod_1-1585236985778.png

 

if you need to filter the macro and run for all locations, i would choose a batch macro to accomplish that task, but you could possibly do it by using groups within the flow itself. From the screenshot below, you look like you want to run single reports, is that correct?

Highlighted
5 - Atom

Yes correct we want to run single reports from the files. I will also give the split option a try. 

Labels