Dynamic Filters/Append/Join for multiple Criteria

[PKoya]

Hi,

I am attempting to create a mechanism where in I can apply as set of filters based on the rules which will be supplied by the business in below format. This can be applied on the attached dataset.

Rule #	Flag	Filter 1	Filter 1 Items	Filter 2	Filter 2 Items	Filter 3	Filter 3 Items
1	Review	Region	West, East	Category	Office Supplies
2	Review	Region	South	Category	Furniture	Sub-Category	Tables
3	Strategy Review	State	California, Florida, Washington, Wisconsin	Category	Furniture	Sub-Category	Tables, Chairs

There will be different number of Filters and each filter will have different items within it. For each row that meets a rule, the value for Flag under that rule will be added to that row.

So in case of Rule # 3, the filter I want to apply would be: ([State] = "California" OR [State] = "Florida" OR [State] = "Washington" OR [State] = "Wisconsin") AND [Category] = 'Furniture' AND ([Sub-Category] = "Tables" OR [Sub-Category] = "Chairs") and want to create a column called Flag which should have value Strategy Review.

However, for Rule # 1, the filter to apply would be ([Region] = "West" OR [Region] = "East") AND [Category] = 'Office Supplies' and the Flag column should have the value Review.

How can I add the Flag dynamically for each row?

Thanks.

[messi007]

@PKoya,

Please see below how you can do it with union, filter and formula tools:

attached the workflow.

Hope this helps !

Regards

[atcodedog05]

Hi @PKoya 

Here is how you can do it using if-else formula.

Workflow:

Hope this helps : )