---
schema_version: "1"
id: 5a688bda28a9b99914e5b34e578eb9e38a073d9148e5e23a985893f2558e1a3a
title: "Drop Columns Transformation: Drop Columns from the Recipe"
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_dropcolumns.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_dropcolumns.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 1cfd7e836fe7c66f7d2f17b056c981d231cd27376c44dd0a1ab31894bbba5c83
description: In CRM Analytics, drop unwanted columns from a Data Prep recipe. For example, you can add a Drop Columns transformation after a Formula transformation to drop input columns used for a calculated column.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Drop Columns Transformation: Drop Columns from the Recipe

In CRM Analytics, drop unwanted columns from a Data Prep recipe. For example, you can add a Drop Columns transformation after a Formula transformation to drop input columns used for a calculated column.

### Required Editions

## Drop Columns Transformation: Drop Columns from the Recipe

<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="d43797e39">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d43797e39 ">To create a recipe:</td>

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

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

1. In a Transform node of a Data Prep recipe, select the column in the Preview tab.
2. In the Transform toolbar, click the Drop Columns button (![Drop Columns 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_dropColumns.png)).
    
    The dropped column appears in the Drop Columns step.
    
    ![The Drop Columns transform setup panel and preview.](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_transformation_dropColumns_edit.png)
3. Alternatively, to keep the columns selected instead of removing them click **Keep**.
    
    ![The Drop Columns set up panel, showing Keep option selected.](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_recipe_transformation_dropColumns_keep.png)
4. To include additional columns, enter their label in the Select Columns to Drop/Keep field.
5. Click **Apply** to add the transformation to the Transform node.![The Steps panel shows the Drop Columns transformation.](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_transformation_dropColumns_step.png)
6. 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)).
7. Save the recipe.

From this point forward, dropped columns can’t be used in recipe transformations and nodes. They also no longer appear in Preview.