Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

REMOVE NULL OR BLANK

Received Response
1131
Views
4
Comments
User_PDZPF
User_PDZPF Rank 1 - Community Starter
edited Aug 13, 2024 5:04PM in Oracle Analytics Forum

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.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    User_PDZPF Rank 1 - Community Starter

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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    User_PDZPF Rank 1 - Community Starter

    Thank you @Gianni Ceresa . It worked fine.