Skip to main content

Data Transformation

Upper Case

Description

This operations helps to convert a given key value into Upper Case from any JSON Dataset. This operations take place while data is in-flight

Number of Parameters : 1

Parameter : Uppercase

Provide comma separated list of keys in double quotes to convert the defined key values into Upper Case

Below is a example where we are converting the value of first_name and last-named into Upper Case

"first_name", "last_name"

Lower Case

Description

This operations helps to convert a given key value into Lower Case from any JSON Dataset. This operations take place while data is in-flight

Number of Parameters : 1

Parameter : Lowercase

Provide comma separated list of keys in double quotes to convert the defined key values into Lower Case

Below is a example where we are converting the value of first_name and last_name into Lower Case

 "first_name", "last_name"


Data Type

Description

Data type can convert any string of boolean, float, integer and datetime into JSON datatype of boolean, float, integer and datetime.


Number of Parameters : 4

Parameter : Boolean

A Boolean can be converted into every key's string value into a Boolean value. In JSON data, Booleans do not contain double quotes.
Example: true or false

Parameter : Float

Convert any string like float into JSON data type float.
Example: "Amount"


Parameter : Integer

Convert any string like integer into JSON data type integer and also converts any string like float into integer and convert a float data type into integer.
Example: "Quantity"

Parameter : Date Time

Can convert any string like date into JSON data type date and can change the format of date. 

From date format : The date/datetime format in which the user is defining their date/datetime.
To date format : The date/datetime format in which the user wants to convert their date/datetime.

Examples-["key_name","From date format","To date format"]


Append

Description: 

Append dynamically or statically adds a new key with a value on the fly, which will add key and its value for each record.

Number of Parameters : 1

Parameter : Append

By adding new elements to the end of an existing data structure, the append operation can help to extend or modify the data structure in a flexible and efficient way.

For dynamic value the user can use {{column_name}} where column_name is the incoming column in the data pipeline
Example


Title Case

Description:

It aids in the conversion of a given key value into title case. 

Number of Parameters : 1

Parameter : Title Case

Title case converts a given key value into title case for any given key name comma separated in double quotes.
Example: "Titlecase":["amount","value"]


Data Extractor

Description: 

Data Extractor operation is designed to extract specific data from JSON response. The data can be in various formats.


Number of Parameters : 2

Parameter : Data_Extractor

Data_Extractor is used to extract keys and its value from a JSON response

Parameter :Data_Extractor_Keys

This helps to provide user defined keys. If left blank it will auto generate keys.
Example:



Trim 

Description: 

Trim helps in removing unnecessary parts from the given key's value as defined by the user.

Number of Parameters : 1

Parameter : It trims the given key's value, Provide comma separated list of keys in double quotes
Example:


JSON to String

Description: 

JSON to String is used to convert JavaScript object or value as its parameter and returns a JSON string 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 : Json2string

Provide comma separated in double quotes, for the values that need to be converted.
Example: "json2string":["key1","key2"]


String to JSON

Description: 

String to JSON is used to converts a string object or value as its parameter and returns a JSON string that represents the object in a specific format required by the user. 


Number of Parameters : 1

Parameter : String2json

Provide comma separated in double quotes, for the values that need to be converted.
Example: "string2json":["key1","key2"]


JSON to XML

Description: 

JSON to XML is used to convert JSON object or value as its parameter and returns a XML that represents the object. The resulting XML can be used to store or transmit data in a structured format.

Number of Parameters : 2

Parameter : Key_data

Key_data converts the provided Key's value from JSON to XML.

Parameter : Response_key

Response_key take note of the converted value under the specified key name which is easy to access.
Example:


XML to JSON

Description: 

XML to JSON is used to convert XML object or value as its parameter and returns a JSON that represents the object. The resulting JSON can be used to store or transmit data in a structured format.


Number of Parameters : 2

Parameter : Get_key

Get_key converts the provided Key's value from XML to JSON

.

Parameter : Response_key

Response_key take note of the converted value under the specified key name which is easy to access.
Example:


Base64 Encoding

Description: 

Base64 operation is used when the user want to convert some specific key to base64, the user can use multiple 
keys if they require.


Number of Parameters : 1

Parameter : Base64_encode

Used to encode the values of given key into base64
Example:


Base64 Decoding

Description: 

Base64 decoding operation is used to converting a Base64-encoded string back to its original data format.


Number of Parameters : 1

Parameter : Base64_decode

Converts the provided key's base64 value into a string by decoding it.
Example:



Generate Array Sequence Number

Description:

Generate Array Sequence Number is a single line of data that presents the sequence the user wants to specify.


Number of Parameters : 2

Parameter : Sequence_key

It is the key name in which the single line data is present whose sequence the user needs to give.

Parameter : Sequence_number_key

It is the name of the new key for sequence
Example:


Send Keys top of Root

Description:

Column_to_root is the key's value specify by the user. User should provide the key name comma separated in double quotes in square brackets


Number of Parameters : 1

Parameter : Column_to_root

column_to_root : column_to_root is the given key's value
Example-["Amount"]



Today Timestamp

Description:

Today Timestamp operation helps to convert any time stamp to the required date and time format.

Number of Parameters : 2

Parameter : Date_format

Date_format used to pass the required format.

Parameter : Datetime_key

Datetime_key is the name of key in which the user wants to save their date


Round

Description:

Round is used to reduce a number to a specific number of decimal places, where the numbers need to be rounded off.

Number of Parameters : 2

Parameter : Round_keys

Round_keys is used to access the specific key that needs to be roundoff, define by the user.

Parameter : Decimal_key_number

Decimal_key_number specifies which decimal places the user needs.
User should provide the key name comma separated in double quotes.
Example:



Calculator

Description: 

Calculator operations are used when a calculated field with sustaining formulas related to any particular process is provided, by the user.

Number of Parameters : 2

Parameter : Calculation_keys

Calculation_keys are used when keys with calculating formula is available. 

Parameter : New_calculation_keys

New_calculation_keys used to  store the calculated values.
User should provide the key name comma separated in double quotes.
Example:

Date Analytics

Description: 

Date analytics is used to specify and define various date formats based on the specification.


Number of Parameters : 4

Parameter : Data_field_key

Data_field_key

Data_field_key is a name or code that is used to identify a particular data field.

Parameter : Fiscal_month_start 

Fiscal_month_start is used to specify the start date of a fiscal month, which is a period of time used by organizations to track their financial performance.

Parameter : Date_column

Date_column is used for new date column key name for saving data.

Parameter : Weekday

Weekday is used to specify the starting of the week.



Repeat First Row Values

Description:

Repeat First Row Values is  used when working with time series data or other data sets where values are expected to remain constant for a certain period of time.

Number of Parameters : 2

Parameter : Source_key

Source_key helps in reading the dataset from a single line.

Parameter : Fields_to_repeat_value

Fields_to_repeat_value is an array of column name's whose first row value we want to repeat.
Example: