Dataset filtering to exclude NULL value

Question & Answer
,
1

image
image394×655 13.7 KB

Do I specify “NULL” as in the screenshot to exclude NULL value? Will this be interpreted as field having string “NULL”?

Thanks.

2

Hi @lbl

Please use the null options as shown below in the screenshot to include or exclude the null data points and apply the custom filter condition to filter the data.

image
image280×756 34.1 KB

Thanks
Vinod

3

I am applying filtering at Dataset and not at Analyses level so that I can apply the same filtering across all analyses from dataset perspective.

There is no include or exclude the null data points at Dataset level.

Please advise for Dataset level.

Thank you.

4

Hi @lbl

Please create calculated field in the dataset to capture the null values and apply the filter on the calculated field to filter the null value records.

In the below example calculated field expression will check for the null/empty/NULL values in the product field and returns null-values .

image
image607×232 7.98 KB

Subsequently create the dataset filter on the calculated field to exclude all the null-values records from the dataset .

image
image396×466 11.2 KB

Thanks
Vinod

1 Like
5

Using of calculated field will increase the dataset size.
And if there are many fields to exclude the NULL, there will be many calculated fields.
Please confirm if calculated field is the only way.

Thanks.

6

Hi @lbl,
If performing at the dataset level, to my knowledge a calculated field is the only way to accomplish this currently.

Let us know if you have any additional questions, if we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

7

Hi @lbl,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!