REMOVE_PROPERTY function

REMOVE_PROPERTY function

Function Name	Description	Usage	Input parameter	Return value
REMOVE_PROPERTY	Removes a property from a JSON object.	REMOVE_PROPERTY(value)	Property name.	Updated JSON object after removing the specified property and its corresponding value.

Supported data type

The REMOVE_PROPERTY function supports the following data type:

• JSON

Example: Remove a property from a JSON object.

Sample data:

$var1$ =
{
 "name": "Alex",
 "address": {
 "street": "1800 Amphibious Blvd",
 "city": "Mountain View",
 "state": "CA",
 "pincode": "94045"
 }
} 

Usage: $var1$.REMOVE_PROPERTY("address.street")

Remove the address.street property from the JSON.

Output:

{
 "name": "Alex",
 "address": {
 "city": "Mountain View",
 "state": "CA",
 "pincode": "94045"
 }
}

Recommendation

• Learn how to add and configure a Data Mapping task