9 Replies Latest reply: Oct 8, 2012 12:29 PM by mrkachhia RSS

    Finding Column Name having minimum value

       

      Need help in finding cheapest source for below table.

       

      Product

      Supplier01

      Supplier02

      Supplier03

      Apple

      10

      20

      12

      Banana

      13

      15

      8

      Orange

      7

      14

      7

      Grapes

      14

      10

      12

       

      Only three supplier is given but actual data is having more than 100 suppliers for 10000 products.

       

      The output should be as below as last two columns are showing results.

       

      Product

      Supplier01

      Supplier02

      Supplier03

      Minimum Price

      Cheapest Supplier

      Apple

      10

      20

      12

      10

      Supplier01

      Banana

      13

      15

      8

      8

      Supplier03

      Orange

      7

      14

      7

      7

      Supplier01, Supplier03

      Grapes

      14

      10

      12

      10

      Supplier02

       

       

       

      Regards,

      Manish Kachhia