You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

I'm trying to use the concat function in ether OTBI or BI to combine 4 fields.

Accepted answer


I have tried using the pipe method (||), the nested method and the case/when. and still can not get this to work. I am trying to to combine cost center information which is 3 separate fields (enity.location.department) then adding the department name and the end. I'm using OTBI then dropping the SQL into a data model. Once i get past 2 strings it just doesn't want to work. I will list the fields in the content area along with the subject areas. Any insight into this will be greatly appreciated, this is the last piece of the puzzle for

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!