Data Table Find Best Row
Find the row with the minimum or maximum value in a field.
Parameters
| Parameter | Description |
|---|---|
| Data Table Source | Select the target DataTable. Set Source, then assign the matching table, asset, or component field that appears. |
| Data Definition | Optional fallback definition used when the resolved DataTable is not available in the editor. |
| Field | The field used for comparison. You can also choose Row Key. |
| Mode | Max finds the highest value. Min finds the lowest value. |
| Index | Stores the zero-based index of the matching row. |
| Found | True when a matching row was found. |
Details
This action compares values across rows and returns the best match by index.
If Field is set to Row Key, comparison uses row keys directly and does not require field data.
Examples
- Find the most expensive shop item using
PricewithMax. - Find the lowest health target using
HealthwithMin.