Forum Discussion

AbhinavJoshi's avatar
AbhinavJoshi
Responsive Resident
2 years ago
Solved

Advance Filtering

Hi Everyone,  I have the following dataset, and I would like to remove the rows where the Type is Child & Spouse and the Value is Single.    ID Type Attribute Value 22 Member SEC F...
Need Help
  • Bipin-Lala's avatar
    Bipin-Lala
    2 years ago

    Hi AbhinavJoshi,

     

    You can create a custom column in Query Editor, let's say "FilterRows" and assign a value to it (like 0) if it matches your conditions for filtering out the rows.

    if ([Type] = "Child" or [Type] = "Spouse") and [Value] = "Single" 
then 0 
else 1

    Now, FilterRows = 0 for all rows that match your conditions, otherwise it's 1

     

    In the next step, you can filter out all rows where FilterRows = 0

     

    This should filter your table as per your requirements. Let me know if you have any other requirements!

     

Bipin-Lala's avatar
Bipin-Lala
Solution Sage
2 years ago

Hi AbhinavJoshi,

 

You can create a custom column in Query Editor, let's say "FilterRows" and assign a value to it (like 0) if it matches your conditions for filtering out the rows.

if ([Type] = "Child" or [Type] = "Spouse") and [Value] = "Single" 
then 0 
else 1

Now, FilterRows = 0 for all rows that match your conditions, otherwise it's 1

 

In the next step, you can filter out all rows where FilterRows = 0

 

This should filter your table as per your requirements. Let me know if you have any other requirements!

 

  • Danilo_Matos's avatar
    Danilo_Matos
    Regular Visitor
    2 years ago

    That's good!