Import structured source data into the ETL pipeline to enable reliable data ingestion, schema validation, and preparation for column splitting and joining transformations.
Import
data
Capture user-defined input parameters such as column names and separators to dynamically control how columns are split and joined within the data pipeline.
Input
Key
Left Column Name
Value
Key
Right Column Name
Value
Key
Separator
Value
Key
New Column Name
Value
Join values from two specified columns using a configurable separator to create a new derived column, supporting flexible data transformation and enrichment use cases.
Code
Javascript
Export the transformed dataset with the newly joined column to Excel format, enabling spreadsheet-based analysis, reporting, and business review.
Code
Javascript
Export the processed dataset to CSV format for efficient data exchange, ETL interoperability, and integration with external analytics systems.
Code
Javascript
Export the finalized dataset to JSON format, providing a machine-readable output optimized for APIs, data pipelines, and modern data platform consumption.
Code
Javascript