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.
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.
Hi sir @Gianni, I'm in DV workbook section trying to filter out/remove blank or 0s in rows.
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.
Thank you @Gianni Ceresa . It worked fine.
