Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Use Variables to set Filter Criteria

njermer
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".

2 REPLIES 2
benakesh
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 . 

 

 

njermer
5 - Atom

Thank you!

Labels