Loading
Prepare for Email to Become the Default Login ExperienceRead More
Salesforce Data Pipelines
Drop Columns Transformation: Drop Columns from the Recipe

You are here:

  1. Salesforce Help
  2. Docs
  3. Salesforce Data Pipelines

Drop Columns Transformation: Drop Columns from the Recipe

In Salesforce Data Pipelines, 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

User Permissions Needed
To create a recipe: Edit CRM Analytics Dataflows OR Edit Dataset Recipes
  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).

    The dropped column appears in the Drop Columns step.

    The Drop Columns transform setup panel and preview.
  3. Alternatively, to keep the columns selected instead of removing them click Keep.
    The Drop Columns set up panel, showing Keep option selected.
  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.
  6. To view the Graph area, click the Collapse button (Collapse button).
  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.

 
Loading
Salesforce Help | Article