1 Reply Latest reply: Nov 1, 2011 3:39 AM by GJ Strydom RSS

    Is it possible with this problem?

      hi guys..i have the problem like this

       

      date     place     value

        2          a          3

        4          a          2

        3          b          9

        6          b          3

       

      the result is

       

      date     place     value

        2          a          3

        3          a          3

        4          a          2

        5          a          2

        6          a          2

        3          b          9

        4          b          9

        5          b          9

        6          b          3

       

       

      how to implement that?

      thanks

        • Is it possible with this problem?

          Hey There,

           

          You could try the below:

           

          In the Script:

           

          "Main":

          Load *

          ;

          SQL SELECT

                     date,

                    place,

                    value

          from yourtable

          order by date, place desc

          ;

           

          Then on the front end create a table box and add the date,place and value fields.

           

          Hope it helps,

           

          Regards GJ.