---
schema_version: "1"
id: cb5a134de49eab38e1a6e62fbd767e2dc846e29751e47938907b660419bbe748
title: "Split Transformation: Break Up Column Values"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_recipe_transformation_split.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_split.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 392bf4f733919b7be871e56783b43445d170384bbe090a7d68d49480607dba3c
description: "In CRM Analytic, you can split the strings in a text column into two values by specifying a delimiter. To split column values into more than two parts, add multiple instances of the Split transformation. For instance, you can use 3 Split transformations in a Data Prep recipe to split the full address into the following components: street address, city, state, and zip code."
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Split Transformation: Break Up Column Values

In CRM Analytic, you can split the strings in a text column into two values by specifying a delimiter. To split column values into more than two parts, add multiple instances of the Split transformation. For instance, you can use 3 Split transformations in a Data Prep recipe to split the full address into the following components: street address, city, state, and zip code.

### Required Editions

## Split Transformation: Break Up Column Values

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d69091e39">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d69091e39 ">To create a recipe:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d69091e39 ">Edit CRM Analytics Dataflows OR Edit Dataset Recipes</td>

          </tr>
        </tbody>
      </table>

1. In a Transform node of a Data Prep recipe, select the text (dimension) column in the Preview tab.
2. In the Transform toolbar, click the Split button (![Split button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_button_split.png)).
    
    ![The Split panel is where you specify the delimiter and new column labels.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_split_edit.png)
3. Select the delimiter in the Delimiter field.
    
    For example, if address components are separated by a comma in the Address field, specify comma as the delimiter.
4. Specify the column labels for both new columns.
5. Click **Apply** to add the transformation to the Transform node.
    
    Going back to the address example, the Address field is split into two. The Split transformation splits the value at the first occurrence of the delimiter. In this case, the first comma appears after the street address. So the full address is broken into the street address and the rest (city, state, and ZIP code).
    
    ![The Preview shows the results.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_split_preview.png)
6. If needed, add the Split transformation again to further split the column values.
    
    For example, to finish splitting the city, state, and ZIP code, we can add two more Split transformations.
    
    ![Preview shows the results. Notice how city, state, and zip code are in separate columns now.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_split_previewAll.png)
7. To view the Graph area, click the Collapse button (![Collapse button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_button_collapse.png)).
8. Save the recipe.

If you don’t need the original column you split, add the Drop Columns transformation after the Split transformation to drop it from the recipe. From that point, the original column doesn’t appear in Preview anymore.