6 Replies Latest reply on Dec 8, 2016 11:18 AM by Anil Pottem

    Pivot a Particular Column on ODBC Connection

    Anil Pottem

      Hi All,


      I have a specific requirement in this I use an ODBC Connection ( Other ODBC Datasources)

       

      I have close to 20 Columns inside the table but I want to only pivot either of this columns 2 columns ( Week Number & Delivery Date )

       

      The Week number column is extracted from Delivery date .

       

      Week Number : for current Year

      48

      49

      50

      51

       

      Requirement is Rolling 4 weeks of data like the one shown below ( I have to show the delivery quantity across delivery week for different product numbers)

       

                  Product Number                           week 48 , week 49 , Week 50 , Week 51

                     A3454334                                       34          51               38                 67

                     A4576897                                       28          22               45               111

                     A5665432                                       42          79               43                 32

       

      Can you please let me know how to achieve this ?

       

      Thanks,