DATASET SORT BY COLUMN¶
Sorts all rows of a dataset by a specified column in ascending or descending order. An optional regex pattern can be used to extract a numeric sub-string from column values before sorting. Use this worker whenever tabular data needs to be reordered before downstream processing or display.
When to use¶
Classification: process.
Tagged: ascending, column, dataset, descending, order, regex, sort, tabular.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Choose Dataset | dataset_1 | dataset | — | Input dataset whose rows will be sorted; must be a tabular dataset object available in the workflow context. | |
| Choose Column | choose_column | text | — | Name of the column to sort by; the available choices are populated dynamically from dataset_1’s column headers. | |
| Choose Order | order_type | select | desc | Sort direction — ‘desc’ (descending, default) or ‘asc’ (ascending); controls whether the largest or smallest values appear first. | |
| Regex | regex | text | — | Optional regular-expression pattern applied to the sort-column values before comparison; e.g. ‘_d+’ extracts the leading digits after an underscore so that label strings such as ‘step_10’ sort numerically rather than lexicographically. Leave blank to sort on the raw cell values. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| dataset_sort_by_column_output_1 | dataset_sort_by_column_output_1 | dataset | A copy of the input dataset with rows reordered according to the chosen column, sort direction, and optional regex extraction; schema (columns and types) is unchanged. |
Disciplines¶
- data.dataset.transform
Runnable example¶
A runnable example is registered for this worker. Open the example workflow on the d3VIEW canvas: /api/workflow/example?id=dataset_sort_by_column
Auto-generated from transformation schema. Worker id: dataset_sort_by_column. Schema hash: 2fa8da3793eb. Hand-curated docs in workerexamples/ override this page when present.