Concatenate with a CASE WHEN STATEMENT - Oracle Business Intelligence - OBI

Donna Fazio

Is it possible to create a CASE WHEN statement and concatenate results?

For example:

CASE WHEN "A" IS NULL THEN 'Orphan -'|| "A" ELSE "A" END

Gianni Ceresa

Yes, it is possible.

Did you try it? Did it work? If no, what error did you get?

What product and version? What is the exact formula you did try?

Just saying: your condition is A is null, but then you want to concatenate 'Orphan -' with null?

Donna Fazio

Thank you so much for your quick response.. Yep.. It is possible. I should have caught my error when i typed this example.

I meant to concatenate with "B" not "A".. Oh dear! End of the week blurs!!

Thanks again!