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
Solved! Go to 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 🙂
@atcodedog05 Thank you so much , this is perfect:)