DATASET SPLIT COLUMN VALUES INTO COLUMNS¶
Splits the distinct values found in a chosen column into separate new columns, pivoting that column’s values across the dataset’s column axis. Use this worker when a single column contains categorical or delimited values that should each become their own column (wide-format expansion).
When to use¶
Classification: process.
Tagged: column-expansion, dataset, pivot, reshape, split, transformation, wide-format.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Dataset | dataset_1 | dataset | — | Input dataset whose column values will be split into new columns; accepts any tabular dataset available in the workflow context. | |
| CSV Column Name | col_name | scalar | — | Name of the column whose distinct values will be pivoted into individual new columns; must match an existing column header in the input dataset exactly (case-sensitive). |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| New Dataset | dataset_split_output_1 | dataset | Transformed dataset with the selected column’s values expanded into separate columns, one per distinct value found in the original column. |
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_split_column_values_into_columns
Auto-generated from transformation schema. Worker id: dataset_split_column_values_into_columns. Schema hash: be08c1996d1b. Hand-curated docs in workerexamples/ override this page when present.