---
schema_version: "1"
id: ecc90ab54228184203dc2b4992b780c533ca5dd4608db2472940cd80039e1ab7
title: Dataflow Conversion Mapping
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_data_prep_upconversion_specs.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_data_prep_upconversion_specs.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 79ad35fd8bda65116c8b72409321947ff2767cc1e9c2642db10418376445e713
description: During conversion, dataflow functionality is mapped to similar recipe functionality. Consider the mapping specifications when evaluating the conversion of your dataflows to recipes.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Dataflow Conversion Mapping

During conversion, dataflow functionality is mapped to similar recipe functionality. Consider the mapping specifications when evaluating the conversion of your dataflows to recipes.

## Dataflow Transformations

At a glance dataflow to recipe conversion mapping.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:36.36363636363637%">
          <col style="width:27.27272727272727%">
          <col style="width:36.36363636363637%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d106618e44">Dataflow</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" id="d106618e47">Conversion</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d106618e50">Recipe</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">append</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Check mark"></span>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Append</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">augment </td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Check mark"></span>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Join</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">computeExpression </td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Check mark"></span>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Transform (Custom formula)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">computeRelative </td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <p>
                <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_green_away.png" alt="Some coverage mark"></span>
              </p>
              <p style="margin-bottom:0;">see parameters</p>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Transform (Custom formula with multiple rows)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">delta</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">&nbsp;</td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">digest</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Check mark"></span>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Input</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">dim2mea</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Check mark"></span>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Transform (Dimension to measure)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">edgemart</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Check mark"></span>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Input</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">export </td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <p>
                <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_green_away.png" alt="Some coverage mark"></span>
              </p>
              <p style="margin-bottom:0;">see parameters</p>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Output (as .csv)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">filter</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Check mark"></span>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Filter</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">flatten </td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Check mark"></span>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Transform (Flatten)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">prediction</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Check mark"></span>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Discovery Predict</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">sfdcDigest</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <p>
                <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_green_away.png" alt="Some coverage mark"></span>
              </p>
              <p style="margin-bottom:0;">see parameters</p>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Input and Transform</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">sfdcRegister</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Check mark"></span>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Output</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">sliceDataset</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Check mark"></span>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">Transform (Drop columns)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e44 ">update</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e47 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Check mark"></span>
            </td>

            <td data-label="Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e50 ">
              <p style="margin-bottom:0;">Update</p>
            </td>

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

append   
| Dataflow Parameter | Conversion | Supported in Recipe |
| --- | --- | --- |
| sources | ![Check mark](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Append |
| enableDisjointedSchemaMerge | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Append (Allow schema merge) |

augment   
| Dataflow Parameter | Conversion | Supported in Recipe |
| --- | --- | --- |
| operation | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Join (lookup) |
| left | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Join (lookup) |
| left\_key | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Join (lookup) |
| right | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Join (lookup) |
| relationship | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Join (lookup) |
| right\_select | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Join (lookup) |
| right\_key | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Join (lookup) |

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small " summary="computeExpression">
        <caption>computeExpression</caption>
        <colgroup>
          <col style="width:26.666666666666668%">
          <col style="width:16.666666666666664%">
          <col style="width:56.666666666666664%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d106618e601">Dataflow Parameter</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" id="d106618e604">Conversion</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d106618e607">Supported in Recipe</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e601 ">mergeWithSource</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e604 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e607 ">Transform (Drop columns)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e601 ">saqlExpression </td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e604 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e607 ">Transform (SQL in custom formula)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e601 ">format</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e604 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e607 ">Transform (Custom formula)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e601 ">fiscalMonthOffset</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e604 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e607 ">
              <p>Use Data Prep Date Configurations </p>
              <p style="margin-bottom:0;">See <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_dataPrep_dateConfiguration.htm&amp;language=en_US" target="_blank">Data Prep Fiscal
                  Configuration</a></p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e601 ">isYearEndFiscalYear</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e604 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e607 ">
              <p>Use Data Prep Date Configurations </p>
              <p style="margin-bottom:0;">See <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_dataPrep_dateConfiguration.htm&amp;language=en_US" target="_blank">Data Prep Fiscal
                  Configuration</a></p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e601 ">firstDayOfWeek</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e604 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e607 ">
              <p>Use Data Prep Date Configurations </p>
              <p style="margin-bottom:0;">See <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_dataPrep_dateConfiguration.htm&amp;language=en_US" target="_blank">Data Prep Fiscal
                  Configuration</a></p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e601 ">precision</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e604 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e607 ">Transform (Custom formula)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e601 ">scale</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e604 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e607 ">Transform (Custom formula)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e601 ">defaultValue</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e604 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_green_away.png" alt="Half icon indicating sometimes true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e607 ">
              <p>Transform (Custom formula)</p>
              <p style="margin-bottom:0;">The defaultValue in dataflows support function
                calls. For example, <code>now()</code>. In recipes,
                function calls aren’t supported and the defaultValue must be a
                literal.</p>
            </td>

          </tr>
        </tbody>
      </table> <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small " summary="computeRelative">
        <caption>computeRelative</caption>
        <colgroup>
          <col style="width:26.666666666666668%">
          <col style="width:16.666666666666664%">
          <col style="width:56.666666666666664%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d106618e796">Dataflow Parameter</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" id="d106618e799">Conversion</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d106618e802">Supported in Recipe</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e796 ">partitionBy</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e799 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e802 ">Transform (Custom formula with multiple rows)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e796 ">orderBy</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e799 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e802 ">Transform (Custom formula with multiple rows)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e796 ">computedFields.name</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e799 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e802 ">Transform (Custom formula with multiple rows)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e796 ">computedFields.label</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e799 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e802 ">Transform (Custom formula with multiple rows)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e796 ">computedFields.description</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e799 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e802 ">&nbsp;</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e796 ">computedFields.expression.sourceField</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e799 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e802 ">Transform (Custom formula with multiple rows)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e796 ">computedFields.expression.offset</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e799 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e802 ">Transform (Custom formula with multiple rows)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e796 ">computedFields.expression.default</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e799 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e802 ">Transform (Custom formula with multiple rows)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e796 ">computedFields.expression.saqlExpression</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e799 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_green_away.png" alt="Half icon indicating sometimes true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e802 ">
              <p>Transform (Custom formula with SQL)</p>
              <p>Self-referencing formulas don’t convert
                and aren’t supported. For example, using computeRelative to create a field
                “MyNewField”, which has SAQL expression referencing
                previous(MyNewField).</p>
              <p>Achieve similar results using recipes. For example, if
                using computeRelative in dataflow to:</p>
              <ul>
                <li>Aggregate based on data grouping, try using recipe Aggregate.</li>
                <li>Concatenate a column’s multiple text values into a column based on a data
                  grouping, try using recipe Join lookup with multivalue and Transformation custom
                  formula with <code>array_join</code>.</li>
                <li>Generate row numbers, try using recipe Transformation custom formula with
                  <code>row_number</code>.
                </li>
                <li>Be used in a filter to keep only the most recent records based on a data
                  grouping - such as the last activity record for an account, try using recipe
                  Aggregate and Filter.</li>
              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e796 ">computedFields.expression.type</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e799 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e802 ">Transform (Custom formula with multiple rows)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e796 ">computedFields.expression.scale</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e799 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e802 ">Transform (Custom formula with multiple rows)</td>

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

**Delta** transform isn’t supported in Recipes. To calculate changes over time, consider using a transformation node with windowing functions in multiple row custom formulas.

digest   
| Dataflow Parameter | Conversion | Supported in Recipe |
| --- | --- | --- |
| connectionName | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Input |
| object | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Input |
| fields | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Input |

dim2mea   
| Dataflow Parameter | Conversion | Supported in Recipe |
| --- | --- | --- |
| measureDefault | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Transform (Dimension to measure) |
| measureType |   |   |

To extract all columns in a dataset, use the **Include All Fields** option in the Input node.

edgemart   
| Dataflow Parameter | Conversion | Supported in Recipe |
| --- | --- | --- |
| alias | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Input |

export   
| Dataflow Parameter | Conversion | Supported in Recipe |
| --- | --- | --- |
| source | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Output (to .csv) |
| target |   |   |
| userId |   |   |

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small " summary="filter">
        <caption>filter</caption>
        <colgroup>
          <col style="width:26.666666666666668%">
          <col style="width:16.666666666666664%">
          <col style="width:56.666666666666664%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d106618e1321">Dataflow Parameter</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" id="d106618e1324">Conversion</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d106618e1327">Supported in Recipe</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1321 ">filter</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e1324 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1327 ">Filter</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Parameter" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1321 ">saqlFilter </td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e1324 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_green_away.png" alt="Half icon indicating sometimes true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1327 ">
              <p>Filter (SQL filter expression)</p>
              <p>SAQL <code>like</code>
                operator may not be converted (depending on complexity) and isn’t
                supported.</p>
              <p style="margin-bottom:0;">Use recipe Transformation custom formula with <code>startsWith</code>, <code>endsWith</code>, or <code>contains</code>.</p>
            </td>

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

flatten   
| Dataflow Parameter | Conversion | Supported in Recipe |
| --- | --- | --- |
| include\_self\_id | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Transform (Flatten) |
| self\_field | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Transform (Flatten) |
| parent\_field | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Transform (Flatten) |
| multi\_field | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Transform (Flatten) |
| path\_field | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Transform (Flatten) |

prediction   
| Dataflow Parameter | Conversion | Supported in Recipe |
| --- | --- | --- |
| predictionDefinitionName | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Discovery Predict |
| predictionColumnName | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Discovery Predict |
| predictionColumnLabel | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Discovery Predict |

sfdcDigest   
| Dataflow Parameter | Conversion | Supported in Recipe |
| --- | --- | --- |
| object | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Input |
| incremental |   |   |
| fullRefreshToken |   |   |
| fields | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Input |
| filterConditions | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Filter (Filter logic) |
| complexFilterConditions |   | Use Filter (SQL expression) |

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small " summary="sfdcDigest">
        <caption>sfdcDigest</caption>
        <colgroup>
          <col style="width:26.666666666666668%">
          <col style="width:16.666666666666664%">
          <col style="width:56.666666666666664%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d106618e1742">Dataflow Field Attributes</th>
            <th scope="col" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" id="d106618e1745">Conversion</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d106618e1748">Supported in Recipe</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Dataflow Field Attributes" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1742 ">name</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e1745 ">
              <span style="vertical-align:text-bottom;display:inline-block;"><img style="margin-bottom:0;" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png" alt="Checkmark icon indicating true"></span>
            </td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1748 ">Input</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Field Attributes" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1742 ">defaultValue</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e1745 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1748 ">Use Transform (Custom formula with <code>case</code> or
              <code>coalesce</code>)
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Field Attributes" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1742 ">type</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e1745 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1748 ">Use Transform (Replace or Custom formula)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Field Attributes" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1742 ">fiscalMonthOffset</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e1745 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1748 ">
              <p>Use Data Prep Date Configurations </p>
              <p style="margin-bottom:0;">See <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_dataPrep_dateConfiguration.htm&amp;language=en_US" target="_blank">Data Prep Fiscal
                  Configuration</a></p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Field Attributes" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1742 ">isYearEndFiscalYear</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e1745 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1748 ">
              <p>Use Data Prep Date Configurations</p>
              <p style="margin-bottom:0;">See <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_dataPrep_dateConfiguration.htm&amp;language=en_US" target="_blank">Data Prep Fiscal
                  Configuration</a></p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Field Attributes" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1742 ">firstDayOfWeek</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e1745 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1748 ">
              <p>Data Prep Date Configurations </p>
              <p style="margin-bottom:0;">See <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_dataPrep_dateConfiguration.htm&amp;language=en_US" target="_blank">Data Prep Fiscal
                  Configuration</a></p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Field Attributes" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1742 ">isMultiValue</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e1745 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1748 ">
              <p>Use Transform (Custom formula multivalue functions)</p>
              <p style="margin-bottom:0;">See <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_multivalueFunctions.htm&amp;language=en_US" target="_blank">Multivalue Functions for
                  Formulas</a></p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Field Attributes" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1742 ">multiValueSeperator</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e1745 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1748 ">
              <p>Use Transform (Custom formula multivalue functions)</p>
              <p style="margin-bottom:0;">See <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_multivalueFunctions.htm&amp;language=en_US" target="_blank">Multivalue Functions for
                  Formulas</a></p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Field Attributes" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1742 ">precision</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e1745 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1748 ">
              <p>Use Transform (Edit attributes)</p>
              <p style="margin-bottom:0;">See <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_editAttributes.htm&amp;language=en_US" target="_blank">Edit Attributes
                  Transformation</a></p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow Field Attributes" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1742 ">scale</td>

            <td data-label="Conversion" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" headers="d106618e1745 ">&nbsp;</td>

            <td data-label="Supported in Recipe" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e1748 ">
              <p>Use Transform (Edit attributes)</p>
              <p style="margin-bottom:0;">See <a href="https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_transformation_editAttributes.htm&amp;language=en_US" target="_blank">Edit Attributes
                  Transformation</a></p>
            </td>

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

sfdcRegister   
| Dataflow Parameter | Conversion | Supported in Recipe |
| --- | --- | --- |
| alias | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Output |
| name | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Output |
| source | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Output |
| rowLevelSharingSource | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Output |
| rowLevelSecurityFilter | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Output |

sliceDataset   
| Dataflow Parameter | Conversion | Supported in Recipe |
| --- | --- | --- |
| source | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Transform (Drop columns) |
| mode | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Transform (Drop columns) |
| fields | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Transform (Drop columns) |

update   
| Dataflow Parameter | Conversion | Supported in Recipe |
| --- | --- | --- |
| left | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Update |
| right | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Update |
| left\_key | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Update |
| right\_key | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Update |
| update\_columns | ![Checkmark icon indicating true](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/_corporate/images/checkmark.png) | Update |

## Dataflow SAQL

Dataflows use SAQL and recipes use SQL. During conversion, SAQL is changed to SQL whenever possible.

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

Warning SAQL date filtering, relative date ranges, and references to date epochs are not supported. Recommendation is to evaluate supported solutions to replace dataflow SAQL date capabilities.

In recipes, try using simple operators with Dates or DateTimes such as `+,-,=,<,>,<=,>=`. For example, add hours by using `(DateTime) + (TimeInterval)`.

Below are instances when SAQL is not automatically converted to SQL, and the recommended SQL alternative. In recipes, use SQL in a Transform custom formula.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d106618e2287">Dataflow (SAQL)</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d106618e2290">Recipe (SQL)</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">DateField_sec_epoch</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">to_unix_timestamp(DateField) </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">DateField_day_epoch</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">to_unix_timestamp(DateField) / (60 * 60 * 24) </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">DateField_Year</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">format_number(year(DateField), '0000') </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">DateField_Quarter</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">format_number(quarter(DateField), ‘0') </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">DateField_Month</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">format_number(month(DateField), '00') </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">DateField_Week</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">format_number(weekofyear(DateField), '00') </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">DateField_Day</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">format_number(day(DateField), '00') </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">DateField_Hour</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">format_number(hour(DateField), '00') </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">DateField_Minute</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">format_number(minute(DateField), '00') </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">DateField_Second</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">format_number(second(DateField), '00') </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">toDate() </td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">to_timestamp() </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">date_to_epoch()</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">to_unix_timestamp() </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">month_first_day(toDate('CloseDate_sec_epoch'))</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">date_trunc('month', CloseDate) </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">month_last_day(toDate('CloseDate_sec_epoch'))</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">date_trunc('month', CloseDate) + INTERVAL 1 month - INTERVAL 1 day </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">
              <p>week_first_day(toDate('CloseDate_sec_epoch')) </p>
              <p style="margin-bottom:0;">This function always returns
                Sunday of the week</p>
            </td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">
              <p>date_trunc('week', CloseDate) </p>
              <p style="margin-bottom:0;">This function always returns Monday of the
                week</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">Other first_day or last_day functions</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">Use date_trunc on the different parts: 'year', 'quarter', 'month', 'week'.
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">toString(toDate('CloseDate_sec_epoch'), "yyyy-MM-dd")</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">date_format(CloseDate, 'yyyy-MM-dd') </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">date_to_string()</td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">date_format(CloseDate, 'yyyy-MM-dd') </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">date_diff("year", toDate(StartDate_sec_epoch), toDate(EndDate_sec_epoch)) </td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">year(EndDate) - year(StartDate)</td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">date_diff("month", toDate(StartDate_sec_epoch), toDate(EndDate_sec_epoch)) </td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">months_between(EndDate, StartDate) </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">date_diff("quarter", toDate(StartDate_sec_epoch), toDate(EndDate_sec_epoch)) </td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">(year(EndDate)-year(StartDate))*4 + quarter(EndDate) - quarter(StartDate)
            </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">date_diff("week", toDate(StartDate_sec_epoch), toDate(EndDate_sec_epoch)) </td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">floor(datediff(EndDate, StartDate) / 7) </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">date_diff("day", toDate(StartDate_sec_epoch), toDate(EndDate_sec_epoch)) </td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">datediff(EndDate, StartDate) </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">date_diff("hour", toDate(StartDate_sec_epoch), toDate(EndDate_sec_epoch)) </td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">(to_unix_timestamp(EndDate) - to_unix_timestamp(StartDate))/(60*60) </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">date_diff("minute", toDate(StartDate_sec_epoch), toDate(EndDate_sec_epoch)) </td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">(to_unix_timestamp(EndDate) - to_unix_timestamp(StartDate))/(60) </td>

          </tr>
          <tr class="">
            <td data-label="Dataflow (SAQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2287 ">date_diff("second", toDate(StartDate_sec_epoch), toDate(EndDate_sec_epoch)) </td>

            <td data-label="Recipe (SQL)" class="slds-cell-wrap" style="vertical-align:top;" headers="d106618e2290 ">to_unix_timestamp(EndDate) - to_unix_timestamp(StartDate) </td>

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