Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Use Variables to set Filter Criteria

Highlighted
5 - Atom

I have an Alteryx workflow that inputs a configuration table containing filter criteria and inputs a dataset. How can an Alteryx workflow apply filter criteria on the dataset based on the configuration table?

 

Example Configuration Table

 

FieldOperandValue
Total Sales>1000

 

Example Data Input

 

City

Total Sales

New York

20000

Miami

100

Tampa

200

Philadelphia

2000

Boston

50

 

I need an Alteryx workflow that will filter the example dataset above based on the configuration table. The configuration table could also have, "Total Sales = 100" or "Total Sales < 2000" or "City IN New York".

12 - Quasar

Hi @njermer ,

Check this and other  resources for dynamic replace tool  .

 

The attached wf  shows  how  to  use dynamic replace tool  for  this  sample data . 

We pass  field name we are updating , expression  ( only true  rows are updated )  and  output value  ( can be expression or  static value)  to R  input  in dynamic replace tool .

Hope this helps . 

 

 

Highlighted
5 - Atom

Thank you!

Labels