6 Replies Latest reply on Apr 28, 2017 7:57 PM by Christian Berg

    OBIEE - concat rows with strings

    3427784

      Hello all -

       

      I am working with web analytics and trying to concatenate multiple rows of strings against a dimension. I have a session ID (column) which has multiple rows of data (another column) and would like to have this column strings together vs. being separated on a row basis.

       

      Example - for the first one, I'd like the strings to be on one line against the "Session_ID" separated with commas. I have tried using the concat function in OBIEE but it is not properly adding them together. Any suggestions are welcomed as I hope that can provide some guidance.

       

      Thank you,

      Andrew