Single Line to Multiline
Overview
Single Line to Multiline converts single-line JSON data into multiline JSON format for structured storage and processing.
Description
This operation restructures flat JSON records into multiline format, improving readability and compatibility with downstream operations.
Number of Parameters
1
Parameter: Chopkey
Adds a new key dynamically with static or dynamic values.
['bizdata_dataset_response']['data']
Delimiter to JSON
Overview
Delimiter to JSON converts delimited text data into structured JSON format.
Description
This operation parses delimiter-separated values and transforms them into JSON objects for standardized data handling.
Number of Parameters
6
Parameters
- Key Data: Holds delimiter data.
- Delimiter: Separator character.
- Fields: Optional column headers.
- Autodetect Column Names: Enables auto header generation.
- Skip Header: Controls header processing.
- Response Key: Stores output JSON.
"Customer ID","Organization Name","Month","Item"
JSON to Delimiter
Overview
JSON to Delimiter converts structured JSON data into delimiter-separated format.
Description
This operation transforms JSON arrays into flat, delimited text files suitable for export.
Number of Parameters
6
Example
"Item1","Item2","Item3"
Data Aggregation
Overview
Data Aggregation groups and summarizes raw datasets for easier analysis.
Description
This operation organizes related records into grouped structures based on unique identifiers.
Number of Parameters
3
Parameters
- Agg Data Key: Source data key.
- Groupby Key: Grouping identifier.
- Array Key: Stores grouped records.
['bizdata_dataset_response']['items']
Unpivot
Overview
Unpivot converts a single object into multiple objects based on transposed values.
Description
This operation restructures column-based values into row-based records.
Number of Parameters
2
"bucket_type","bucket_value"
Pivot
Overview
Pivot combines multiple objects into a single object using transposed keys and values.
Description
This operation restructures datasets by promoting selected attributes to root-level keys.
Number of Parameters
3
Example Parameters
Get Key: attributes Transposed Key: "attributename" Transposed Value: "attributevalue"
Single Line to Tuple
Overview
Single Line to Tuple converts flat data into tuple structures.
Description
This operation maps single-line records into ordered tuples based on header configuration.
Number of Parameters
3
"Item","Customer","Month"
Tuple to Single Line
Overview
Tuple to Single Line converts tuple data into flat JSON format.
Description
This operation maps tuple elements back into structured single-line records.
Number of Parameters
3
Delimiter to Array
Overview
Delimiter to Array converts delimiter-separated values into arrays.
Description
This operation splits delimited strings into list structures for processing.
Number of Parameters
2
"email" Delimiter: ","
Zipfile in Base64
Overview
Zipfile in Base64 generates a Base64-encoded ZIP file from multiple records.
Description
This operation packages multiple files into a ZIP archive and encodes it as a Base64 string.
Number of Parameters
5
Parameters
- Source Key
- File Name Key
- File Extension Key
- File Data Key
- Base64 Response Key
"items","FILE_NAME","EXTENSION","FILE_DATA","File_string"
Frequently Asked Questions
What is the purpose of Delimiter to JSON?
It converts delimiter-separated text into structured JSON format.
When should Data Aggregation be used?
It should be used when grouping and summarizing related records.
What does Pivot operation do?
It promotes selected attributes to root-level keys in the dataset.
Can Text files be converted into arrays?
Yes, using the Delimiter to Array operation.
Why use Zipfile in Base64?
It enables secure packaging and transmission of multiple files.
Notes
- Verify parameter formatting before execution.
- Test transformations using sample datasets.
- Apply operations sequentially for consistent results.
