| Excerpt |
|---|
Unpacks array data into separate rows for each value. This transform operates on a single column. |
This transform does not reference keys in the array. If your array data contains keys, use the unnest transform. See Unnest Transform.
| D code |
|---|
flatten col: myArray |
Output: Generates a separate row for each value in the array. Values of other columns in generated rows are copied from the source.
| D code |
|---|
flatten: col: column_ref |
| Token | Required? | Data Type | Description |
|---|
| flatten | Y | transform | Name of the transform |
| col | Y | string | Source column name |
Identifies the column to which to apply the transform. You can specify only one column.
| Required? | Data Type |
|---|
| Yes | String (column name) |
| Include Page |
|---|
| EXAMPLE - Flatten an Array |
|---|
| EXAMPLE - Flatten an Array |
|---|
|
While the above example nicely flattens out your data, there are two potential problems with the results:
- There is no identifier for each test. For example, Allen Adams' score of 87 cannot be associated with the specific test on which he recorded the score.
- There is no unique identifier for each row.
The following example addresses both of these issues. It also demonstrates differences between the unnest and the flatten transform, including how you use unnest to flatten array data based on specified keys.
| Include Page |
|---|
| EXAMPLE - Flatten and Unnest Transforms |
|---|
| EXAMPLE - Flatten and Unnest Transforms |
|---|
|
| D s also |
|---|
| label | wrangle_transform_flatten |
|---|
|
