Loading
CRM Analytics
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Drop Columns Transformation: Drop Columns from the Recipe

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            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

            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