Min / List Layer
Find the minimum value in each variable-length numeric list. Similar to numpy.min() or R's min(). Returns null for empty lists.
Example transformation:
| lists | min |
|---|---|
| [1, 5, 3, 2] | 1 |
| [-2, 0, 8, -1] | -2 |
| [4] | 4 |
| [4, null, 2, null] | 2 |
| [] | null |
| [null, null] | null |
Common applications:
- Finding lowest prices in transaction history
- Detecting minimum temperatures in weather data
- Identifying best response times
- Analyzing system resource bottlenecks
- Finding minimum stress points
- Determining optimal entry points
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 low values in variable-length sequences.
Table
0
0
Table
Select
columnThe variable-length numeric list column to analyze. Examples:
- Price history: [10.5, 9.8, 11.2, 9.5]
- Performance metrics: [0.12, 0.09, 0.15]
- Temperature readings: [-2.1, 0.5, -1.8, -0.5]
- Load measurements: [1200, null, 950, 1100] 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.