How to exclude multiple fields using Action Button

[hykal1993]

Hi,

Quick question, how do I exclude multiple fields with "No" in a set of data?

Say for example, column A, B, C and D has "Yes" and "No" value. I would like to exclude the row only if all columns show "No".

Thanks in advance

[techvarun]

Create a Fourth Column as a key by concatenating A, B and C

A&B&C as Key

And exclude where Key ='NoNoNo';

[techvarun]

Or you can write a where condition as A&B&C <>'NoNoNo' this will avoid on additional Load incase of Huge Data

[hykal1993]

A,B and C is variable created from the script. Can I call them again to create another variable on top of that?

Actually, I just need a button where when I press it will exclude only rows where all A, B and C are "No".

[techvarun]

Its easy to do via Script by creating a Flag.

Please share the scenario and sample data if you don't mind

[hykal1993]

I can't share the actual file but I can share a mocked file.