REMOVE NULL OR BLANK

User_PDZPF

Hi, I'm new in Oracle Analytics Cloud. Kindly assist me on how to remove or filter out null values in specific data column rows? Thank you.

Gianni Ceresa

In what part of OAC? There are 3 different places where you could be seeing data: a "classic" analysis, a DV workbook, a BI Publisher dataset.

User_PDZPF

Hi sir @Gianni, I'm in DV workbook section trying to filter out/remove blank or 0s in rows.

Gianni Ceresa

You add a filter and turn it into an exclusion instead of inclusion. Like in this example I did select "Null" and then clicking on the "..." option I switch from "Include Selections" to "Exclude Selections".

Select all the values you don't want and then change the behavior from inclusion to exclusion.

User_PDZPF

Thank you @Gianni Ceresa . It worked fine.