DATASET MERGE TEXT COLUMNS FROM ROWS¶
Merges the values of one or more text columns across all rows of a dataset into a single concatenated string, separated by a user-defined delimiter. Use this worker when you need to flatten multi-row text fields from selected columns into one combined text output.
When to use¶
Classification: process.
Tagged: columns, concatenate, dataset, delimiter, merge, rows, text.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Dataset | dataset_1 | dataset | — | Input dataset whose rows will be scanned; leave unconnected only if chaining dynamically — at least one column must contain text values to merge. | |
| Columns to Merge | col_name | scalar | — | One or more column names from dataset_1 whose row values will be concatenated; multi-select list is populated automatically from the connected dataset. | |
| Delimiter | delimiter | scalar | , | Character or string used to separate merged values in the output (default: comma ‘,’); set to a space, pipe, or newline as needed. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| Merged Text | merged_text | textarea | Single concatenated string containing all row values from the selected columns, joined in row order using the specified delimiter. |
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_merge_text_columns_from_rows
Auto-generated from transformation schema. Worker id: dataset_merge_text_columns_from_rows. Schema hash: f1c23aa5f71b. Hand-curated docs in workerexamples/ override this page when present.