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

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.

Page 1 / 1

You can add a compomnent filter i.e.

Filter Division IS NOT NULL ;

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."

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.

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

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN