Filtering with complex criteria

Dear community,

I would like to ask how we can flag those line which is not as per the criteria below :

Criteria

1 Under each ID, every line for the "GBV_FF" ,it would need to be appear under negative column (which mean positive will be zero) and each line for the "OC", it would need to appear under positive column - This ID will be categorised as Correct ID (as per example screenshot below).

2. Under each ID , If "GBV_FF" appear under positive column and "OC"appear under negative column, This ID will be categorised as Incorrect ID. (as per example screenshot below).

3. Under each ID , If "GBV_FF" appear under positive column and "OC"appear under negative column . This ID will be categorised as Incorrect ID despite we have more and others mapping .As long as " If "GBV_FF" appear under positive column and "OC"appear under negative column, it will automatically appear as Incorrect ID.

For example, in the screenshot below, we have "GBV_FF" , "MS", "OC". Despite we have additional or other item like "OC" under one ID, as long as "GBV_FF" show positive column and "OC" show negative column, it will flag as Incorrect ID

May i know how can we fix for this part?

Thank you

Checking Criteria.xlsx

Developer

Common Use Cases

Accepted answers

All comments

atcodedog05

Hi @SH_94

Here is how you can do it.

Workflow:

Hope this helps : )

group flag.yxmd

SH_94

Hi @atcodedog05 ,

Thank you for your prompt response.

I was looking at the solution and i forget to add in overall criteria

Overall criteria

For the above three criteria listed, it actually applicable only if the each ID consist of "GBV_FF" and "OC" disregard whether it is positive or negative.

If "GBV_FF" or "OC" missing under one ID, it will flag as N/A ID.

Do you know how to fix this part? For example , the line below should be flag as N/A ID.

Thank you.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703