3 Replies Latest reply: Oct 2, 2018 7:23 AM by Andrea Gigliotti RSS

    combine

    DN WEB

      I have to combine all into one chart

        • Re: concatenate
          Sunny Talwar

          May be this

           

          Table:

          LOAD Sales,

              Month,

              Year,

              Category,

              KPI,

              Country,

              brace

          FROM

          [..\..\Downloads\Tests.xlsx]

          (ooxml, embedded labels, table is Sheet1);


          Concatenate (Table)

          LOAD Sales,

              Month,

              Year,

              'All' as Category,

              KPI,

              Country,

              brace

          Resident Table;

           

          or this

           

          Table:

          LOAD Sales,

              Month,

              Year,

              Category,

              KPI,

              Country,

              brace

          FROM

          [..\..\Downloads\Tests.xlsx]

          (ooxml, embedded labels, table is Sheet1);


          Concatenate (Table)

          LOAD DISTINCT Sales,

              Month,

              Year,

              'All' as Category,

              KPI,

              Country,

              brace

          Resident Table;

          • Re: concatenate
            Ruan Greeff

            If you were to create this additional category then there would be no data for it, why do you want to create a third category instead of just selecting two categories simultaneously?

            • Re: concatenate
              Andrea Gigliotti

              You can do it with a new table as below:

               

              tab_a:

              load

                   Category

                   Category as New_Category

              Resident now;

              concatenate

              load

                   Category,

                   'all' as New_Category

              Resident now;


              In the UI you can use New_Category field as filter/dimension.


              I hope it helps.