Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.