Filter the records based on condition

[Ekta]

Hi All, 

Doesn't seems too tough but i am unable to get the correct formula, Any help will be highly appreciated,

Field	value	group
qqqqqqq	111	1
Apple	222	1
aaaa	333	2
ddddd	444	2

i would like to filter the records based on condition - 

if Field contains Apple then filter all the records ie group 1 and 2

but if Field does not contains Apple then only filter group = 1

output if Field contains apple                        

Field	value	group
qqqqqqq	111	1
Apple	222	1
aaaa	333	2
ddddd	444	2

 and if Field does not contain apple the output is 

Field	Value	group
qqqqqqq	111	1
Apple	222	1

Regards

[atcodedog05 · Accepted solution]

Hi @Ekta 

Interesting scenario. Here is how you can do it.

Workflow:

1. Using formula check if field contains apple and creating a flag.

2. Using summarize taking max of flag. If any row contains apple then flag 1.

3. Using append tool to add this column to data.

4. In filter tool checking either [contains apple]=1 or [group]=1

Please check the output. I have creates 2 scenarios with and without apples

Hope this helps 🙂

[Ekta]

@atcodedog05 Thank you so much , this is perfect:)