Min / Array Layer
Find the minimum value in each fixed-length numeric array. Similar to numpy.min() or R's min().
Example transformation (arrays of length 3):
| arrays | min |
|---|---|
| [1, 5, 3] | 1 |
| [-2, 0, 8] | -2 |
| [4, null, 2] | 2 |
| [null, null, null] | null |
Common applications:
- Finding lowest values
- Minimum score detection
- Lowest reading identification
- Range analysis
Note: All arrays must have the same fixed length. Only works with numeric arrays. Arrays containing all null values return null.
Table
0
0
Table
Select
columnThe fixed-length numeric array column to analyze. All arrays must have same length:
- Integer arrays: [1, 2, 3]
- Float arrays: [1.5, 2.7, 3.2]
- Mixed numeric arrays: [1, 2.5, 3]
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.