normalize
normalize [column]
Extracts keys and values from the provided column containing stringified JSON (if no column is provided, the row is considered to be an array)
arguments:
column
The column to normalize. (type: string)
examples:
Query
seed '[{"array": [{ "key": "value1" },{ "key": "value2" }]}]'
|| normalize array
Results prior to normalize stage:
| array.0.key | array.1.key |
|---|---|
| value1 | value2 |
Results after normalize stage:
| key |
|---|
| value1 |
| value2 |
flags:
--appendStage
Used to append the results from a previous stage to the current stage. (provide a label, stage index, or boolean true to append the previous results)
--attributes
A comma separated list of attributes to include in the command results. If not provided, all attributes will be included.
--cache
A boolean value of true/false that determines whether or not to use the cache. Generally most commands will default to true.
--filter
A filter to run on the command results before completing the command. If not provided, no filter is run on the results.
--labelStage
Used to label a stage with a user provided label.
--stats
Controls if a stats calculation is run on a stage after it completes.