MDP Apply Unnest Transformers

The unnest transformer enables you to transform concatenated values into separate rows. The measurement values linked to the nested row are duplicated to each new row. For example, If there are three values, comma-separated, and one field must be broken out into individual rows of data, this transformer creates individual rows for each value in that field.

1. Navigate to the Import tab.
2. Expand Data Streams List.
3. Create a data stream, or edit an existing one.
4. In the Preview Source screen, click Edit Transformers.
5. In the Add Transformers area, next to the Unnest Transformer, click the blue plus icon.
6. In the Column field, select the column that you want to transform.
7. In the Delimiter field, enter the delimiter that is used in the selected column data to separate between the values to be unnested.
8. In the Unnest Column Name field, enter the name of the new column to be created in the file. The column specifies the number of values included in the nested row. If you want to divide the measurement values between the new rows, set a function in the mapping process that divides the measurement value by the number specified in this column.
9. To indicate which column that you want to initiate the process, select the By Column Index checkbox. (If necessary, you can apply multiple unnest transformers to the same column.)
10. Click Done.