How to replace NUll value

building semantic layer
1

Hello All,

I have a column called “Region”, I want to create an object if Region" IS NULL then ‘UNASSIGNED’ ELSE Region?

How can i acheive this please assist?

Thanks for your help
SH

SH3230 (BOB member since 2010-10-25)

2

What database!

Nick Daniels :uk: (BOB member since 2002-08-15)

3

It’s oracle…

SH3230 (BOB member since 2010-10-25)

4

The function you are looking for is NVL.

Lugh (BOB member since 2009-07-16)

5

Yup, like this:
nvl(region, ‘UNASSIGNED’)

ebeth (BOB member since 2012-10-31)