Skip to content
Reference > Prepare Methods

stack(value)

Definition

Number stack(Number value)

Description

running sum of value from first to row n, inclusive

Parameter Definition

Name Type Description
value Number

Example

1
Prepare *,stack(Price) as Sample from SampleData Partition by Symbol

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
+------+--------+-----+------+
|Symbol|Sequence|Price|Sample|
+------+--------+-----+------+
|CAT   |1       |50.0 |50.0  |
|CAT   |2       |54.0 |104.0 |
|CAT   |3       |52.0 |156.0 |
|CAT   |4       |52.0 |208.0 |
|CAT   |5       !null |208.0 |
|CAT   |6       |57.0 |265.0 |
|IBM   |1       |20.0 |20.0  |
|IBM   |2       |24.0 |44.0  |
|IBM   |3       |22.0 |66.0  |
|IBM   |4       |27.0 |93.0  |
|IBM   |5       !null |93.0  |
+------+--------+-----+------+