11 Replies Latest reply: Feb 3, 2017 8:06 AM by Aehman K RSS

    Merge two rows??

    Juna Sharma

      Hi All,

      I have a dimension DSI, which consists of two rows 1) null and 2)values less than 14.

      I want to merge these two rows .

      How can  do it??

      I have other dimensions in the table which are exactly same except DSI??

       

      Thanks Juna

        • Re: Merge two rows??
          Aehman K

          Merge as in include those values from other dimension like

          Example1:

          ABC     XYZ

          1              2

          3              4

           

          to

          ABCXYZ

          1

          2

          3

          4

           

          or

          Example2:

          ABC

          1,2

          3,4 ?

           

          I do not know how to achieve the first example but for 2nd example (values side by side) use

          ABC& ' , ' &XYZ as ABCXYZ,

          In the script use above syntax.

          Perhaps you have a sample data or a screenshot or how you want it?

          If someone can explain how to get the result for example 1 it will be helpful for me as well.

           

          Thanks.

          • Re: Merge two rows??
            Juna Sharma

            Hi,

             

            This is the scenario I am talking about... I want to merge these two rows being based on DSI . First row is null and second will always have values les than 14 . Is there a way we can sum these two rows that results in one row?

             

               

            ABDSIFLAGCMeasuresMeasures
            12 Y000
            125y0073