Max / List Layer
Find the maximum value in each variable-length numeric list. Similar to numpy.max() or R's max(). Returns null for empty lists.
Example transformation:
| lists | max |
|---|---|
| [1, 5, 3, 4, 2] | 5 |
| [-2, 0, 8] | 8 |
| [4] | 4 |
| [4, null, 2, null] | 4 |
| [] | null |
| [null, null] | null |
Common applications:
- Finding peak prices in trading data
- Detecting maximum sensor readings
- Identifying highest scores in competitions
- Analyzing performance peaks
- Finding maximum load in system metrics
- Determining peak usage periods
Note: Only works with numeric lists. Null values are ignored unless list is empty or contains only nulls, then returns null. Lists can have any length. Particularly useful for finding extreme values in variable-length sequences.
Table
0
0
Table
Select
columnThe variable-length numeric list column to analyze. Examples:
- Price series: [10.5, 11.2, 10.8, 12.1]
- Temperature readings: [-2.1, 0.5, 3.2]
- Performance metrics: [85, 92, 88, 95]
- Load measurements: [1200, 1150, 1300] Lists can have different lengths. Only numeric types supported.
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.