---
schema_version: "1"
id: 647fda71cb39b80ea0bc25a10c640d1cc68813fce2816472efe751e792e1bb6a
title: edgemart Transformation
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_edgemart_transformation.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_edgemart_transformation.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f5a01046e84f708f7efdf1e3c9a3faabb4a6da0b88d3aa1508aceb94e65a899c
description: The edgemart Transformation gives the dataflow access to an existing, registered dataset, which can contain Salesforce data, external data, or a combination of the two. Use this transformation to reference a dataset so that its data can be used in subsequent transformations in the dataflow. You can use this transformation and the augment transformation together to join an existing dataset with a new dataset.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# edgemart Transformation

The edgemart Transformation gives the dataflow access to an existing, registered dataset, which can contain Salesforce data, external data, or a combination of the two. Use this transformation to reference a dataset so that its data can be used in subsequent transformations in the dataflow. You can use this transformation and the augment transformation together to join an existing dataset with a new dataset.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note To pull data from an existing dataset in a Data Prep recipe, see [Create a Recipe with Data Prep](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_create.htm&release=264.0.0&type=5 "Use a Data Prep recipe in CRM Analytics to clean, transform, and enrich data before loading it into one or more targets. Preview your results as you build the recipe to confirm that the logic is correct."). To do it in a Data Prep Classic recipe, see [Create a Recipe with Data Prep Classic](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_start_recipe_dataset.htm&release=264.0.0&type=5 "Use a Data Prep Classic recipe to transform data before loading it into a dataset. Only Government Cloud users can create recipes with Data Prep Classic. All other users, including those using Government Cloud Plus, must use Data Prep to create recipes.").

![Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_example.png)

Example

Let’s look at an example. You would like to compare the final sales amount against the opportunity amount to determine if heavy discounts were offered to close deals. You previously created and registered the FinalSales dataset. The FinalSales dataset contains the final sale amount of each opportunity that was closed and won.

FinalSales Dataset    
| OppID | UpdateDate | StageName | SaleAmount |
| --- | --- | --- | --- |
| 1 | 1/1/2014 | ClosedWon | 100,000 |
| 2 | 11/1/2013 | ClosedWon | 150,000 |
| 3 | 2/1/2014 | ClosedWon | 200,000 |

You would now like to create a dataset that contains opportunity information from the Opportunity object. Then, you would like to join the data from the existing FinalSales dataset with the Opportunity dataset.

You create the following dataflow definition.

```
{
    "Extract_Opportunities": {
        "action": "sfdcDigest",
        "parameters": {
            "object": "Opportunity",
            "fields": [
                { "name": "Id" },
                { "name": "Name" },
                { "name": "Amount" }
            ]
        }
    },
    "Extract_Final_Sales_Data": {
        "action": "edgemart",
        "parameters": { "alias": "FinalSales" }
    },
    "Combine_Opportunities_FinalSales": {
        "action": "augment",
        "parameters": {
            "left": "Extract_Opportunities",
            "left_key": [ "Id" ],
            "relationship": "Opportunity",
            "right": "Extract_Final_Sales_Data",
            "right_key": [ "OppID" ],
            "right_select": [ "SaleAmount" ]
        }
    },
    "Register_Opportunity_FinalSales_Dataset": {
        "action": "sfdcRegister",
        "parameters": {
            "alias": "OpportunityVersusFinalSales",
            "name": "OpporunityVersusFinalSales",
            "source": "Combine_Opportunities_FinalSales"
        }
    }
}
```

- **[edgemart Parameters](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_edgemart_transformation_operation.htm&release=264.0.0&type=5)**  
    When you define an edgemart transformation, you set the action attribute to `edgemart` and specify the parameters.