Skip to main content
Question

How could be replaced the NULL values in an OLAP Table?

  • February 1, 2024
  • 4 replies
  • 9 views
H
Level 2
Forum|alt.badge.img+5

In the latest project, an OLAP table was employed, featuring distinct attributes for each individual case.

 

Certain attributes are not universally applicable across all cases. We know that Celonis automatically inserts "-" in null values; however, we aim to modify this default value to "no information." Despite attempts using functions such as coalescence, case when is null, case when isnull(), none of these methods have proven successful.

 

Could you kindly suggest an alternative approach? If additional details are required, please feel free to request them.

 

Thank you for your assistance.

1 Attachments

    4 replies

    abhishek.chatu14
    Level 11
    Forum|alt.badge.img+4

    You can add a compomnent filter i.e.

    Filter Division IS NOT NULL ;

    H
    Level 2
    Forum|alt.badge.img+5
    • hector.torre
    • Author
    • Level 2
    • February 2, 2024

    You can add a compomnent filter i.e.

    Filter Division IS NOT NULL ;

    Thank you for your assistance. However, what I require differs from the provided solution. I need to display all the rows, but instead of showing "-", I would like to show the term "without information."

    matt.witty13
    Level 10
    • matt.witty13
    • Level 10
    • February 2, 2024

    Thank you for your assistance. However, what I require differs from the provided solution. I need to display all the rows, but instead of showing "-", I would like to show the term "without information."

    CASE WHEN [the field you're trying to see] IS NULL

    THEN "Without Information"

    ELSE [the field]

    END

     

    You want to put together a CASE WHEN that evaluates whether something is NULL or not and then replace them.

    janpeter.van.d
    Level 12
    Forum|alt.badge.img+26

    Thank you for your assistance. However, what I require differs from the provided solution. I need to display all the rows, but instead of showing "-", I would like to show the term "without information."

    Pro tip: you could use COALESCE to simplify this: https://docs.celonis.com/en/pql-performance-optimization-guide.html#idm45512777655072

    Community Code of ConductAccessibility statement