Use Variables to set Filter Criteria

[njermer]

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

Field	Operand	Value
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".

[benakesh · Accepted solution]

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 . 

[njermer]

Thank you!