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".
Solved! Go to 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 .
Thank you!