Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table which contains <blank> entries (showed in color light grey with a sign '-').
I would like to select these entries - but I cannot filter or select them.
Is there a best practice - maybe a link to a manual which can help here?
Example - Column 3 contains 2 values with sign '-' which I cannot select or filter:
Header 1 | Header 2 | Here I would like to select <blank> fields marked with sign - | Header 4 | Header 5 |
---|---|---|---|---|
Apple | Name 1 | Alpha | Other | adsf |
Apple | Name 2 | - | Other | qer |
Melon | Name 3 | Beta | Test | asdf |
Melon | Name 4 | Alpha | Test | asdf |
Banana | Name 5 | - | Test | qewqr |
Hi Omar
First you can take that field which contains NULL values in a list box or Filter pane and "select all". After that take your Primary Key Field into Filter Pane and Select Excluded.
Regards
Ahmed
you can assign a value for - and make it selectable
Hi Omar,
try something like:
IF(isnull("name of the Field with blanks.."),'N/A', "name of the Field with blanks..") as "name of the Field with blanks.."
Than you can select N/A instead of blanks..