The order of the columns listed in the function determines the order in which they are searched.
- If you need to perform analysis across multiple columns of heterogeneous data, see Analyze across Multiple Columns.
- If you need to perform analysis across multiple homogeneous columns, see Calculate Metrics across Columns.
derive value: COALESCE([col1,col2,col3]) as: 'firstValue'
Output: Generates the
firsValue column, which contains the first non-missing detected in
col3 in that order.
derive value: COALESCE([col_ref1,col_ref2, col_ref3])
A reference to a single column does not require brackets. References to multiple columns must be passed to the function as an array of column names.
|col_ref1||Y||string||Name of the first column to find the first non-missing value|
|col_ref2||N||string||Name of the second column to find the first non-missing value|
|col_ref3||N||string||Name of the third column to find the first non-missing value|
For more information on syntax standards, see Language Documentation Syntax Notes.
col_ref1, col_ref2, col_ref3
Name of the column(s) searched for the first non-missing value.
|Required?||Data Type||Example Value|
|Yes||String (column reference)|
Example - Find first time
You are tracking multiple racers across multiple heats. Racers might sit out heats for various reasons.
Here's the race data.
Use the following transform to grab the first non-missing value from the Heat columns:
derive value:COALESCE([Heat1, Heat2, Heat3]) as:'firstTime'