Skip to content
Reference > Prepare Methods

lastNotNull(value)

Definition

Object lastNotNull(Object value)

Parameter Definition

Name Type Description
value Object

Example

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