1 Reply Latest reply: May 24, 2013 1:33 AM by 1010562 RSS

    column value convert into number of columns

    1010562
      Hi Friends,
      I have requirement below. Please find below source data for eg

      YEAR PROD MONTH AMOUNT
      1990 A JAN 3000
      1990 A FEB 4000
      1990 A MAR 5000
      2000 B JAN 3000
      2000 B FEB 4000
      2000 B MAR 5000

      now i want output like below

      YEAR PROD JAN FEB MAR
      1990 A 3000 4000 5000
      2000 B 3000 4000 5000

      The values of column "Month" becomes and column and i dont know how many distinct values are coming from source.....



      Thanks in advance
      Khalid Momin