Extracts the key values from an Object data type column and stores them in an array of String values. |
Column reference example:
Output: Returns an array of all of the keys found in the key-value Objects found in the object1 column.
| Argument | Required? | Data Type | Description |
|---|
| obj_col | Y | String or Object | Name of column or Object literal whose keys are to be extracted into an array |
obj_col
Object literal or name of the Object column whose keys you want to extract into an array.
| Required? | Data Type | Example Value |
|---|
| Yes | Object literal or column reference | myObj |
Example - Basic keys example
Source:
Following dataset contains configuration blocks for individual features. These example blocks are of Object type.
Code formatting has been applied to the Object data to improve legibility.
| FeatureName | Configuration |
|---|
| Whiz Widget | {
"enabled": "true",
"maxRows": "1000",
"maxCols": "100"
} |
|
| Magic Button | {
"enabled": "false",
"startDirectory": "/home",
"maxDepth": "15"
} |
|
| Happy Path Finder | |
Transformation:
The following transformation extracts the key values from the Object data in the Configuration column.
Results:
The keys_Configuration column contains the arrays of the key values.
| FeatureName | Configuration | keys_Configuration |
|---|
| Whiz Widget | {
"enabled": "true",
"maxRows": "1000",
"maxCols": "100"
} |
| ["enabled","maxRows","maxCols"] |
|
| Magic Button | {
"enabled": "false",
"startDirectory": "/home",
"maxDepth": "15"
} |
| ["enabled","startDirectory","maxDepth"] |
|
| Happy Path Finder | | |
Example - Create an Object of product properties
