--- schema_version: "1" id: f61f97a1f186f5a0a8fd2c7b38f4b0d3428727701629a13f7ebcd3f62d4ec591 title: Apply Unnest Transformers in Marketing Cloud Intelligence collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_data_streams_tc_transformers_unnest_apply.md canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_streams_tc_transformers_unnest_apply.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 004be593ddb78f348804bf48f7487ca12529af2fabfe9f4419a6fc82c9fc6cb6 description: 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. products: - Marketing - Marketing Cloud Intelligence release: "264" --- # Apply Unnest Transformers in Marketing Cloud Intelligence 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. ### Required Editions
User Permissions Needed
To apply transformers: Admin
1. From the **Connect & Mix** tab, select **Data Streams**, and then **Data Streams List**. 2. Create a data stream, or edit an existing one. 3. In the **Preview Source** screen, click **Edit Transformers**. 4. In the **Add Transformers** area, next to the **Unnest Transformer**, click the blue plus icon. 5. In the **Column** field, select the column that you want to transform. 6. In the **Delimiter** field, enter the delimiter that is used in the selected column data to separate between the values to be unnested. 7. 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. 8. 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.) 9. Click **Done**. Example of Unnest Original file:
Day Campaign Name Campaign Key media buy Key Impressions Clicks Media Cost
3/5/2015 Camp1 8423517 mb1, mb4;mb5 500 50 2500
3/5/2015 Camp2 8423518 mb2, mb22, mb10;mb11 900 90 9000

3/6/2015

Camp3

 8423519

mb3,mb6;mb7,mb8;mb9

 1000 1000 1000
Unnest transformer: ![Showing details of unnest transformer on Media Buy Key](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/data/data_streams_unnest_trans.png) Result:
Day

Campaign Name

 Campaign Key

media buy Key

 unnest1 Impressions Clicks Media Cost

3/5/2015

 Camp1 8423517

mb1, mb4

 2 500 50

2500

3/5/2015

Camp1

8423517 mb5 2 500 50 2500

3/5/2015

Camp2

 8423518

mb2, mb22, mb10

 2 900 90 9000

3/5/2015

 Camp2 8423518 mb11 2 900 90 9000

3/6/2015

 Camp3 8423519

mb3,mb6

 3 1000 1000 1000

3/6/2015

 Camp3 8423519

mb7,mb8

 3 1000 1000 1000

3/6/2015

 Camp3 8423519 mb9 3 1000 1000 1000
If you want to divide the measurement values by the number of new rows, add a function to the measurement’s mapping. For example, for Impressions, use this formula: `csv['Impressions']/csv['unnest 1']` You can further separate the values from the previous file by adding a second unnest transformer: ![Unnest transformer details with delimiter is comma](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/data/data_streams_unnest_trans2.png) Result:
Day

Campaign Name

 Campaign Key media buy Key unnest1 unnest2 Impressions Clicks

Media Cost

3/5/2015

 Camp1 8423517 mb1 2 2 500 50 2500

3/5/2015

Camp1

8423517

 mb4 2 2 500 50 2500

3/5/2015

 Camp1 8423517 mb5 2 1 500 50 2500

3/5/2015

 Camp2 8423518 mb2 2 3 900 90 9000

3/5/2015

 Camp2 8423518 mb22 2 3 900 90 9000

3/5/2015

 Camp2 8423518 mb10 2 3 900 90 9000

3/5/2015

 Camp2 8423518 mb11 2 1 900 90 9000

3/6/2015

 Camp3 8423519 mb3 3 2 1000 1000 1000

3/6/2015

 Camp3 8423519 mb6 3 2 1000 1000 1000

3/6/2015

 Camp3 8423519 mb7 3 2 1000 1000 1000
3/6/2015 Camp3 8423519 mb8 3 2 1000 1000 1000
3/6/2015 Camp3 8423519 mb9 3 1 1000 1000 1000
To divide the measurement’s values, you must add the unnest2 column to the formula, for example, for Impressions: `csv['Impressions']/(csv['unnest1']*csv['unnest2']`)