4 Replies Latest reply: Aug 10, 2018 7:43 AM by manoj kumar RSS

    Combining Multiple Fields

    micro win

      Hello,

       

      I have a table with all the following fields:

       

      Date (DD/MM/YYYY) / Expiration_Date (DD/MM/YYYY) / Total_1 / Expiration_Date_2 (DD/MM/YYYY) / Total_2

       

      With this fields I need to show this table (which I've done and it's ok):

       

      DateExpiration_Date_1Total_1
      28/3/201819/1/2021$ 1,52
      28/3/201818/1/2019$ 2,29
      28/3/201818/1/2022$ 2,29
      28/3/20183/4/2018$ 2,35
      28/3/20182/7/2018$ 2,35
      28/3/20183/10/2018$ 2,35
      28/3/201831/12/2018$ 2,35
      28/3/20182/4/2019$ 2,35
      28/3/20181/7/2019$ 2,35
      28/3/20182/10/2019$ 2,35
      28/3/201830/12/2019$ 2,35
      28/3/201830/3/2020$ 2,35
      28/3/201830/6/2020$ 2,35
      28/3/201830/9/2020$ 2,35
      28/3/201830/12/2020$ 2,35
      28/3/201830/3/2021$ 2,35
      28/3/201830/6/2021$ 2,35
      28/3/201830/9/2021$ 2,37
      28/3/201810/10/2018$ 2,80
      28/3/201828/5/2018$ 2,94
      28/3/201828/8/2018$ 2,94
      28/3/201828/11/2018$ 2,94
      28/3/201828/2/2019$ 2,94
      28/3/201828/5/2019$ 2,94
      28/3/201828/8/2019$ 2,94
      28/3/201828/11/2019$ 2,94
      28/3/201827/2/2020$ 2,94
      28/3/201827/5/2020$ 2,94
      28/3/201827/8/2020$ 2,94
      28/3/201830/11/2020$ 2,94
      28/3/201825/2/2021$ 2,94
      28/3/201826/5/2021$ 2,94
      28/3/201826/8/2021$ 2,94
      28/3/201829/11/2021$ 2,94
      28/3/201823/2/2022$ 2,96
      28/3/201820/1/2020$ 3,05
      28/3/201816/4/2018$ 4,00
      28/3/201823/5/2018$ 5,00
      28/3/201825/6/2018$ 5,00
      28/3/201825/7/2018$ 5,00
      28/3/201826/10/2018$ 5,00
      28/3/201819/7/2018$ 5,50
      28/3/201817/8/2018$ 7,80
      28/3/201811/5/2018$ 9,93
      28/3/201823/4/2018$ 10,00
      28/3/20184/6/2018$ 12,00
      28/3/201827/4/2018$ 18,00
      28/3/20185/9/2018$ 20,00

       

      But now I need to add this other table to my previous table:

       

      DateExpiration_Date_2Total_2
      28/3/20183/4/2018$ 8,56
      28/3/20184/4/2018$ 9,06
      28/3/201811/5/2018$ 9,93

       

      And then have the following, all in a single table:

       

      DateExpiration_DateTotal
      28/3/201819/1/2021$ 1,52
      28/3/201818/1/2019$ 2,29
      28/3/201818/1/2022$ 2,29
      28/3/20183/4/2018$ 2,35
      28/3/20182/7/2018$ 2,35
      28/3/20183/10/2018$ 2,35
      28/3/201831/12/2018$ 2,35
      28/3/20182/4/2019$ 2,35
      28/3/20181/7/2019$ 2,35
      28/3/20182/10/2019$ 2,35
      28/3/201830/12/2019$ 2,35
      28/3/201830/3/2020$ 2,35
      28/3/201830/6/2020$ 2,35
      28/3/201830/9/2020$ 2,35
      28/3/201830/12/2020$ 2,35
      28/3/201830/3/2021$ 2,35
      28/3/201830/6/2021$ 2,35
      28/3/201830/9/2021$ 2,37
      28/3/201810/10/2018$ 2,80
      28/3/201828/5/2018$ 2,94
      28/3/201828/8/2018$ 2,94
      28/3/201828/11/2018$ 2,94
      28/3/201828/2/2019$ 2,94
      28/3/201828/5/2019$ 2,94
      28/3/201828/8/2019$ 2,94
      28/3/201828/11/2019$ 2,94
      28/3/201827/2/2020$ 2,94
      28/3/201827/5/2020$ 2,94
      28/3/201827/8/2020$ 2,94
      28/3/201830/11/2020$ 2,94
      28/3/201825/2/2021$ 2,94
      28/3/201826/5/2021$ 2,94
      28/3/201826/8/2021$ 2,94
      28/3/201829/11/2021$ 2,94
      28/3/201823/2/2022$ 2,96
      28/3/201820/1/2020$ 3,05
      28/3/201816/4/2018$ 4,00
      28/3/201823/5/2018$ 5,00
      28/3/201825/6/2018$ 5,00
      28/3/201825/7/2018$ 5,00
      28/3/201826/10/2018$ 5,00
      28/3/201819/7/2018$ 5,50
      28/3/201817/8/2018$ 7,80
      28/3/201811/5/2018$ 9,93
      28/3/201823/4/2018$ 10,00
      28/3/20184/6/2018$ 12,00
      28/3/201827/4/2018$ 18,00
      28/3/20185/9/2018$ 20,00
      28/3/20183/4/2018$ 8,56
      28/3/20184/4/2018$ 9,06
      28/3/201811/5/2018$ 9,93

       

      Is there any way to do that?

       

      Thank you!!!

        • Re: Combining Multiple Fields
          Manas BN

          Wouldn't a simple concatenation help with this? Or am I missing something in the question?

           

          Table:

          Load Date, Expiration_Date, Total from QVD;

           

          concatenate (Table)

          Load Date, Expiration_Date_2 as Expiration_Date,  Total_2 as Total from QVD;

          • Re: Combining Multiple Fields
            Pooja Singh

            you can concatenate or join your table to bring your data together. Please find followinh example.

             

            Script:-

             

            Table:

            LOAD Date,Expiration_Date_1 AS Expiration_Date ,Total_1 AS Total

            Inline [Date,Expiration_Date_1,Total_1

            28/03/2018,19/01/2021,$1,52

            28/3/2018, 18/1/2019, $ 2,29

            28/3/2018, 18/1/2022, $ 2,29

            28/3/2018, 3/4/2018, $ 2,35

            28/3/2018, 2/7/2018, $ 2,35

            28/3/2018, 3/10/2018 ,$ 2,35];

            Concatenate

            Load Date,Expiration_Date_2 AS Expiration_Date,Total_2 AS Total

            Inline [Date,Expiration_Date_2,Total_2

            28/3/2018, 3/4/2018, $ 8,56

            28/3/2018 ,4/4/2018, $ 9,06

            28/3/2018, 11/5/2018, $ 9,93];

            UI:-Untitled.png

            • Re: Combining Multiple Fields
              arvind pednekar

              Table1:

              Load Date,Expiration_Date_1 AS Expiration_Date ,Total_1 AS Total inline [

               

              DateExpiration_Date_1Total_1
              28/3/201819/1/2021$ 1,52
              28/3/201818/1/2019$ 2,29
              28/3/201818/1/2022$ 2,29
              28/3/20183/4/2018$ 2,35
              28/3/20182/7/2018$ 2,35
              28/3/20183/10/2018$ 2,35
              28/3/201831/12/2018$ 2,35
              28/3/20182/4/2019$ 2,35
              28/3/20181/7/2019$ 2,35
              28/3/20182/10/2019$ 2,35
              28/3/201830/12/2019$ 2,35
              28/3/201830/3/2020$ 2,35
              28/3/201830/6/2020$ 2,35
              28/3/201830/9/2020$ 2,35
              28/3/201830/12/2020$ 2,35
              28/3/201830/3/2021$ 2,35
              28/3/201830/6/2021$ 2,35
              28/3/201830/9/2021$ 2,37
              28/3/201810/10/2018$ 2,80
              28/3/201828/5/2018$ 2,94
              28/3/201828/8/2018$ 2,94
              28/3/201828/11/2018$ 2,94
              28/3/201828/2/2019$ 2,94
              28/3/201828/5/2019$ 2,94
              28/3/201828/8/2019$ 2,94
              28/3/201828/11/2019$ 2,94
              28/3/201827/2/2020$ 2,94
              28/3/201827/5/2020$ 2,94
              28/3/201827/8/2020$ 2,94
              28/3/201830/11/2020$ 2,94
              28/3/201825/2/2021$ 2,94
              28/3/201826/5/2021$ 2,94
              28/3/201826/8/2021$ 2,94
              28/3/201829/11/2021$ 2,94
              28/3/201823/2/2022$ 2,96
              28/3/201820/1/2020$ 3,05
              28/3/201816/4/2018$ 4,00
              28/3/201823/5/2018$ 5,00
              28/3/201825/6/2018$ 5,00
              28/3/201825/7/2018$ 5,00
              28/3/201826/10/2018$ 5,00
              28/3/201819/7/2018$ 5,50
              28/3/201817/8/2018$ 7,80
              28/3/201811/5/2018$ 9,93
              28/3/201823/4/2018$ 10,00
              28/3/20184/6/2018$ 12,00
              28/3/201827/4/2018$ 18,00
              28/3/20185/9/2018$ 20,00

               

              ];

               

              Concatenate(Table1)


              Table2:

              Load Date,Expiration_Date_2 AS Expiration_Date,Total_2 AS Total

              inline [

               

              DateExpiration_Date_2Total_2
              28/3/20183/4/2018$ 8,56
              28/3/20184/4/2018$ 9,06
              28/3/201811/5/2018$ 9,93


              ];

              • Re: Combining Multiple Fields
                manoj kumar

                IT is a simple question just rename the fields like table 1 by using alias it will auto- concatenate else you will do force concatenate r use join you will get one table as like your requirement