Import the source dataset and initialize the pipeline with raw rows containing the delimited column to be processed.
Import
data
Collect user input parameters defining which column to split, the separator character, and the names of the new output columns.
Input
Key
Column Name To Split
Value
Key
Separator
Value
Key
New Column Name 1
Value
Key
New Column Name 2
Value
Split the specified column value using the provided separator and map the resulting parts into two new columns while preserving original data.
Code
Javascript
Export the transformed dataset with the newly split columns to Excel format for spreadsheet-based analysis and reporting.
Code
Javascript
Export the transformed dataset to CSV format for easy data exchange and interoperability with external systems.
Code
Javascript
Export the final transformed dataset to JSON format for programmatic consumption and downstream data pipelines.
Code
Javascript