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
Solved! Go to Solution.
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
Type a few into the tool to get format, switch to xml view (1), click edit (2), copy and paste into a better editor like notepad then paste back the finished formula (3), click the OK button (cut off)
transposing the data worked, thanks a lot!