SELECT_NEWEST

Action

Bases: BaseSchemaAction

Create a new field by iterating over a list of fields and selecting the newest value in the list.

Script template

"SELECT_NEWEST > 'destination_field' < ['source_field' + 'source_field_date', 'source_field' + 'source_field_date', etc.]"

Where + links two columns together, explicitly declaring that the date in source_field_date is used to assign the order to the values in source_field. Unlike the SELECT action, SELECT_NEWEST takes its ordering from this date assignment.

Example

"SELECT_NEWEST > 'occupation_state_date' < ['Current Relief Award Start Date' + 'Current Relief Award Start Date', 'Account Start date' + 'Account Start date']"