Data Wrangling
Single Line to Multiline
Description : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxSingle Line to Multiline is used to convert Single Line JSON to Multiline JSON that represents the object.
The resulting JSON string can be used to store or transmit data in a structured format.
Number of Parameters : 1
Parameter : Chopkey
Chopkey generatesadds a new key with its value as a static or dynamic value on the fly. This will add the key and its value for each record.
Example:
Delimiter to JSON
Description : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxDelimiter to JSON is used to convert Delimiter to JSON that represents the object.
The resulting JSON string can be used to store or transmit data in a structured format.
Number of Parameters : 6
Parameter : Key_data
Key_data adds a new key-value to each record, the user can iterate through the records and add the new key-value to each one.
Parameter : Delimiter
Delimiter is used to separate values in a list, record, or file.
Parameter : Fields
Files is used in to specify headers name.
Parameter : Autodetect_column_names
Autodetect_column_names are for same header which is flat file "true" otherwise false
Parameter : Skip_header
Skip_header uses "false" if the user wants firstline of flatfile as headers
Parameter : Response_key
Response_key is the key in which the user's JSON data will be stored.
Example:
JSON to Delimiter
Description : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxJSON to Delimiter is used to convert JSON to Delimiter that represents the object.
The resulting Delimiter can be used to store or transmit data in a structured format.
Number of Parameters : 6
Parameter : Key_data
Key_data adds a new key-value to each record, the user can iterate through the records and add the new key-value to each one.
Parameter : Delimiter
Delimiter is used to separate values in a list, record, or file.
Parameter : Fields
Files is used in to specify headers name.
Parameter : Autodetect_column_names
Autodetect_column_names adds a new key on the fly with its value as a static value or dynamic value. This will add key and its value for each record.
Parameter : Skip_header
Skip_header uses "false" if the user wants firstline of flatfile as headers
Parameter : Response_key
Response_key is the key in which our delimiter data will be stored
Data Aggregation
Description:
Data aggregation operations areis used infor the processing of raw data.data, Theythis will also help in the grouping, summarizing, and processing of the data to make it easier to understand and analyze.
Number of Parameters : 3
Parameter : Agg_data_key
Agg_data_key is used to empty for multiline data and will have data key in case of singlelinesingle line data
Parameter : Groupby_key
Groupby_key gives key name that the user wants to group by, basically this is a unique identifier in the dataset.
Parameter : Array_key
Array_key gives the key name where the user wants to hold the common keys, the user can provide any key name
Parameter : Array_key_nested_columns
Array_key_nested_columns gives the key name as comma separated keys that should be reflected in the level of groupby_key. This will be outside the array key.
Example:
Unpivot
Description:
Unpivot operations are usedhelps in the data transformation process.
Number of Parameters : 2
Parameter : Transpose_key_name
Transpose_key_name used in specify name of key which needneeds to be transposed
Parameter : Transpose value
Transpose value used in specify the values which needneeds to be transposed
Example:
Pivot
Description:
Pivot operations are used in pivoting data, which involves converting long data to wide data. They are often used in data analysis to transform data into an easier format.
Number of Parameters : 3
Parameter : Get key
Get key helpsis inused convertingto empty for multiline data and will have get key in tocase of single line data.
Parameter : Transpose_key_name
Transpose_key_name specifies name of the key which needs to be transposed.
Parameter : Transpose value
Transpose value specifies which values needs to be transposed.
Example:
Single Line to Tuple
Description:
Single Line to Tuple operations is used to convert a single line of data to a tuple.
Number of Parameters : 3
Parameter : Singleline_key
Singleline_key helps in reading the dataset from a single line.
Parameter : Table_headers
Table_headers specifies the key name that is available inside the array.
Parameter : Tuple_key
Tuple_key is the key which is used to save the tuple data
Tuple to Singleline
Description:
Tuple to Singleline is used in converting a tuple to a single line, which involves taking a tuple object and converting it to a singlesingleline string of values.
Number of Parameters : 3
Parameter : Tuple_keySingleline_key
Tuple_keySingleline_key helpsis inused to readingread the existinguser's tuple data.data .
Parameter : Tuple_keyTable_headers
HeadersTable_headers specifiesare the headers or key name of the new JSON
JSON.
Parameter : Tuple_key
Singleline_key helps in to save the new datadata.