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_name 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


Number of Parameters : 4

Parameter : Data Type


Append

Description


Number of Parameters : 1

Parameter : Append


Title Case

Description


Number of Parameters : 1

Parameter : Title Case


Data Extractor

Description


Number of Parameters : 2

Parameter : Data Extractor


TrimĀ 

Description


Number of Parameters : 1

Parameter : Trim


JSON to String

Description


Number of Parameters : 1

Parameter : JSON to String


String to JSON

Description


Number of Parameters : 1

Parameter : String to JSON


JSON to XML

Description


Number of Parameters : 2

Parameter : JSON to XML


XML to JSON

Description


Number of Parameters : 2

Parameter : XML to JSON


Base64 Encoding

Description


Number of Parameters : 1

Parameter : Base64 Encoding


Base64 Decoding

Description


Number of Parameters : 1

Parameter : Base64 Decoding


Generate Array Sequence Number

Description


Number of Parameters : 2

Parameter : Generate Array Sequence Number



Send Keys top of Root

Description


Number of Parameters : 1

Parameter : Send Keys top of Root



Today Timestamp

Description


Number of Parameters : 2

Parameter : Today Timestamp



Round

Description


Number of Parameters : 2

Parameter : Round



Calculator

Description


Number of Parameters : 2

Parameter : Calculator



Date Analytics

Description


Number of Parameters : 4

Parameter : Date Analytics



Repeat First Row Values

Description


Number of Parameters : 2

Parameter : Repeat First Row Values