Version: v2.3 
MultiWindowAnalytics
Type
transform
Fields
| Name | Title | Description |
|---|---|---|
| partitionByCols | PartitionBy | partition column names separated by comma(,) |
| orderByCols | OrderBy | order by column names separated by comma(,) |
| windowFunctions | Window Function | Window Function Name |
| analyticsCols | AnalyticsColumn | |
| outPutColumns | OutPutColumn | Enter output field(column) name |
Examples
Input
| id | price | lotsize | bedrooms | bathrms | stories |
|---|---|---|---|---|---|
| 1 | 42000 | 5850 | 3 | 1 | 2 |
| 2 | 38500 | 4000 | 2 | 1 | 1 |
| 3 | 49500 | 3060 | 3 | 1 | 1 |
| 4 | 60500 | 6650 | 3 | 1 | 2 |
| 5 | 61000 | 6360 | 2 | 1 | 1 |
| 6 | 66000 | 4160 | 3 | 1 | 1 |
| 7 | 66000 | 3880 | 3 | 2 | 2 |
Parameters
Input
| id | price | lotsize | bedrooms | bathrms | stories | lag | firstvalue |
|---|---|---|---|---|---|---|---|
| 6 | 66000 | 4160 | 3 | 1 | 1 | 60500.0 | 66000.0 |
| 7 | 66000 | 3880 | 3 | 2 | 2 | 66000.0 | 66000.0 |
| 4 | 60500 | 6650 | 3 | 1 | 2 | 49500.0 | 66000.0 |
| 3 | 49500 | 3060 | 3 | 1 | 1 | 42000.0 | 66000.0 |
| 1 | 42000 | 5850 | 3 | 1 | 2 | 66000.0 | |
| 5 | 61000 | 6360 | 2 | 1 | 1 | 38500.0 | 61000.0 |
| 2 | 38500 | 4000 | 2 | 1 | 1 | 61000.0 |