4 Replies Latest reply: Aug 2, 2011 8:43 AM by Matan Chalamish RSS

    How to load 2 rows to 1 row according parameter

    Matan Chalamish

      Hello All.

      It's look like very simple question...

       

      Please look at the script on the attached qvw.

       

      In this script I has:

       

      LOAD * INLINE [

          ACT, PARAM, COEF

          1, W, 3.66

          1, M, 1

          2, W, 2.5

          2, M, 1

          3, W, 3.4

          3, M, 1.5

      ];

       

      Now, I want to get a table without duplicity. In this table - for every ACT it will be only 1 row.

      So, if the PARAM = 'W' the COEF falue will be under Final.WorkerCoef

      AND, if the PARAM = 'M' the COEF falue will be under Final.MachineCoef

       

      Actualy I want to show a Table Box (NOT Chart) look like:

       

      Final.Act Final.MachineCoef Final.WorkerCoef
      1 1 3.66
      2 1 2.5
      3 1.5 3.4

       

      Any suggestions?

       

      Thank you!