---
schema_version: "1"
id: 9e606d15d5eb3035bfb56307459180d9dcc3adc88435e10275648a4878d54353
title: Categorize Text Column Values into Buckets
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_batch_transform_bucket_dimension.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_bucket_dimension.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: a18c410f7464ed069c873f8144c622d9cd6c005530a700b8d999f84b1ca2a77d
description: Use a column field to categorize and organize text values, including email, phone, and URL. For example, to group by region, you can create the buckets West, Central, and East.
products:
  - Data 360
release: "264"
---
# Categorize Text Column Values into Buckets

Use a column field to categorize and organize text values, including email, phone, and URL. For example, to group by region, you can create the buckets West, Central, and East.

1. In the Transform node, select the dimension field in the Preview tab.
2. In the Transform toolbar, click the **Bucket** button (![Create bucket button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_data_prep_bucket_icon.png)) to define the buckets.
    
    ![The left panel provides options to define the buckets.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_integrate_bucket_dimensions_edit.png)
3. Click ![Add bucket button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_integrate_data_prep_recipe_add_filter_condition_button.png).
4. Enter a label for the bucket.
    
    ![The Define Range modal allows you to set the bucket label and range.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_integrate_bucket_define_dim_bucket.png)
5. In the Values Included in Bucket box, search for and select the values to be assigned to this bucket. If a value doesn’t appear in the list, adjust your sample size or refine your search. Then, click **Add new value** and enter the value.
6. Click **Add**.
7. To create more buckets, click ![Add bucket button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_integrate_data_prep_recipe_add_filter_condition_button.png) and select a label and the values to assign to the bucket.
8. To place null values into their own bucket, select **Bucket null values**.
9. To place values not otherwise bucketed together in a bucket, select **Bucket remaining values** then specify the name for this group.
10. To bucket similarly spelled values together, select **Apply smart bucketing**. To change the edit distance, use the Distance Threshold slider. Einstein uses the [Levenshtein distance](https://en.wikipedia.org/wiki/Levenshtein_distance) for fuzzy matching. The default edit distance is set to 1, which means that a single-character edit is allowed for text matching. For example, with an edit distance of 2, variations such as flavor, Flavor, flavour, and flavors all can belong in the same bucket. By default, differences in uppercase and lowercase characters are ignored.
11. Under Show Results In, select whether the buckets appear in a new field and what happens to the original field.
12. If you elect to create a field, set the label under Column Label.
13. Click **Apply** to add the transformation to the Transform node. The Preview tab shows the new bucket field.
14. To view the canvas, click the **Collapse** button (![Collapse button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_button_collapse.png)).
15. Click **Save**.

After you run the batch data transform, you can view the bucket assigned to each row in the bucket column.