3 Replies Latest reply: Jun 28, 2016 6:53 AM by Sunny Talwar RSS

    How to Split in Dimension

    kapil rathore

      Q - How to Split in Dimension

       

      I have a Pivot table that holds the data as -

       

      Col1     |  Col2    | Col3                        | Value

      Val1     |   Val2    |  Val-X,Val-Y,Val-Z     |    3

      Val1     |   Val2    |  Val-A,Val-B,Val-C    |    2

       

      here Col1, Col2 and Col3 are the Dimensions and Value is the expression

       

      I wanted to split Col3 delimited by comma (,)  in multiple Rows as -

       

      Col1     |  Col2    | Col3                        | Value

      Val1     |   Val2    |  Val-X                      |    3

                               |  Val-Y                      |    3

                               |  Val-Z                      |    3

      Val1     |   Val2    |  Val-A                      |    2

                               |  Val-B                      |    2

                               |  Val-C                      |    2