Function returns the first non-missing value found in an array of columns.
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.
Output: Returns the first non-missing detected in
col3 in that order.
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:
|Parameter: Formula type||
|Parameter: New column name||
This page has no comments.