Skip to content
Reference > Prepare Methods

lastNotNull(value)

Definition

Object lastNotNull(Object value)

Parameter Definition

Name Type Description
value Object

Example

Prepare *,lastNotNull(Price) as Sample from SampleData Partition by Symbol
+------+--------+-----+------+
|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  |
+------+--------+-----+------+