Alteryx Designer Discussions

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

Possible a Macro to automatically filter rows and select fields ?

horse9118
7 - Meteor

Hello, 

 

I have a workflow that would run a series of data validations and then output the rows that failed each validation to a separate tab in an Excel report. The workflow for each check is similar, I filter on the rows that failed the check, and then select the relevant fields that related to that check (will be different for each check), add a "TabName" field that equals to the name of the check, and then output the Tab to the excel file. The problem with this is that I have over 100 data validations that I have to run, so I have to manually create each workflow, which is also opening the workflows up for errors.

 

I wonder if its possible to make a excel sheet with 2 fields, Check_Name and Selected_ Fields like this

 

Check_Name, Selected_Fields

Check_1, Field1

Check_1, Field2

Check_2, Field1

Check_2, Field3

 

and then have build an macro to parse through the excel spreadsheet to replicate the workflow? 

 

  

 

1 REPLY 1
Qiu
17 - Castor

@horse9118 
An iteration macro should be a good fit for this task.
I Just "imagined" some data since there is no sample data provided.

1022_Horse9118.PNG1022_Horse9118-1.PNG

Labels