Skip to content
Reference > Prepare Methods

count(value)

Definition

Integer count(Object value)

Description

running count where value!=null and value!=false to the current row, inclusive

Parameter Definition

Name Type Description
value Object value to test for not null and not false

Example

1
Prepare *,count(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 |1     |
|CAT   |2       |54.0 |2     |
|CAT   |3       |52.0 |3     |
|CAT   |4       |52.0 |4     |
|CAT   |5       !null |4     |
|CAT   |6       |57.0 |5     |
|IBM   |1       |20.0 |1     |
|IBM   |2       |24.0 |2     |
|IBM   |3       |22.0 |3     |
|IBM   |4       |27.0 |4     |
|IBM   |5       !null |4     |
+------+--------+-----+------+