Multiple field filter (check if fields are not empty)

Question

Hi all,

Is there any kind of workaround for a multi field filter?

I would like to filter my rows of data, based on the entry of a specific set of fields.

Lets assume I want to keep those records, which have entries in the fields "W1750" "W1751" and "W1753"(example attached).

It works fine, if I write a custom filter with the following formula:

!IsNull([W1750]) OR !IsNull([W1751]) OR 
!IsNull([W1753])

However in reality, I have a quite of a dozen fields I want to check.

Is there any way to load this set of fields, so I don't have to type them manually in the custom filter formula?

Thanks for your help.

Benjamin

multifield_Example.yxmd

bpatel · Accepted Answer

hi @Link ,

you can transpose the data first and filter on one column. hope this helps!

trettelap · Accepted Answer

I believe this should get you what you are looking for.

I transposed the fields that I wanted to filter on, filtered out the names that had all nulls, grouped by the name field to remove duplicates, and then joined the results back into the original data.

This should adapt if you add more columns as well if you leave the "unknown columns" checked in the transpose tool

ImadZidan · Accepted Answer

Hello @Link ,

an idea.

Hope it helps