Combination of rec and fntriv. Get first non blank for all the records with the same key.
Note: This produces a result for EVERY record that is a function of the other records.
LOANID recfntriv LOANPURP
KeyField recfntriv TextField
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| KeyField | Text | Field | Key | No |
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| TextField | Text | Field | No |
Type: Text
First non-blan value of all records with the same key