Avoiding Nulls in a Column

[Anonymous]

Hi

Please find the attached application , I am trying to avoid Nulls in the Feature column , I have use len and trim in the script for RUM Group and RUM Feature columns(Service Time Series RUM Tab in Script) , but still I see Nulls values in the Group : Feature filter.

Can someone please help me in avoiding the null values in Feature column both from tables and filters.

Thank you!

[alexpanjhc · Accepted solution]

It sounds like you do not want to load in to the null at all, so in pre load, can you do

SQL SELECT *

FROM "Operational Xcellence: RUM Time Series bj32atvjv"

where len("Group Mapping")>0 and  len("Feature Mapping")>0;

[Anonymous]

Hi,

You can also right click in your table, click on properties, on Dimension tab select RUM Feature and check the box 'Suppress when value is null'. After that, click on OK.

Best Regards,