ARRAY_LOOKUP
All functions > ARRAY > ARRAY_LOOKUP
Returns the value corresponding to a lookup key using parallel key-value arrays.
Syntax
ARRAY_LOOKUP(lookup_key: T, keys: ARRAY<T>, values: ARRAY<U>) → Usql
Type Parameters:
T: Any comparable typeU: Any type
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
lookup_key | T | Yes | The key to search for |
keys | ARRAY<T> | Yes | Array of keys |
values | ARRAY<U> | Yes | Array of values (parallel to keys) |
Returns
Value type - The value at the same position as the key
Notes
- Uses two parallel arrays: one for keys, one for values
- Returns the value at the same index where the key is found
- Returns NULL if key is not found
- Only returns the first match if key appears multiple times
- Arrays must be same length