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.

Dataflow	Conversion	Recipe
append		Append
augment		Join
computeExpression		Transform (Custom formula)
computeRelative	see parameters	Transform (Custom formula with multiple rows)
delta
digest		Input
dim2mea		Transform (Dimension to measure)
edgemart		Input
export	see parameters	Output (as .csv)
filter		Filter
flatten		Transform (Flatten)
prediction		Discovery Predict
sfdcDigest	see parameters	Input and Transform
sfdcRegister		Output
sliceDataset		Transform (Drop columns)
update		Update

append

Dataflow Parameter	Conversion	Supported in Recipe
sources		Append
enableDisjointedSchemaMerge		Append (Allow schema merge)

augment

Dataflow Parameter	Conversion	Supported in Recipe
operation		Join (lookup)
left		Join (lookup)
left_key		Join (lookup)
right		Join (lookup)
relationship		Join (lookup)
right_select		Join (lookup)
right_key		Join (lookup)

computeExpression

Dataflow Parameter	Conversion	Supported in Recipe
mergeWithSource		Transform (Drop columns)
saqlExpression		Transform (SQL in custom formula)
format		Transform (Custom formula)
fiscalMonthOffset		Use Data Prep Date Configurations See Data Prep Fiscal Configuration
isYearEndFiscalYear		Use Data Prep Date Configurations See Data Prep Fiscal Configuration
firstDayOfWeek		Use Data Prep Date Configurations See Data Prep Fiscal Configuration
precision		Transform (Custom formula)
scale		Transform (Custom formula)
defaultValue		Transform (Custom formula) The defaultValue in dataflows support function calls. For example, now(). In recipes, function calls aren’t supported and the defaultValue must be a literal.

computeRelative

Dataflow Parameter	Conversion	Supported in Recipe
partitionBy		Transform (Custom formula with multiple rows)
orderBy		Transform (Custom formula with multiple rows)
computedFields.name		Transform (Custom formula with multiple rows)
computedFields.label		Transform (Custom formula with multiple rows)
computedFields.description
computedFields.expression.sourceField		Transform (Custom formula with multiple rows)
computedFields.expression.offset		Transform (Custom formula with multiple rows)
computedFields.expression.default		Transform (Custom formula with multiple rows)
computedFields.expression.saqlExpression		Transform (Custom formula with SQL) 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). Achieve similar results using recipes. For example, if using computeRelative in dataflow to: Aggregate based on data grouping, try using recipe Aggregate. 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 array_join. Generate row numbers, try using recipe Transformation custom formula with row_number. 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.
computedFields.expression.type		Transform (Custom formula with multiple rows)
computedFields.expression.scale		Transform (Custom formula with multiple rows)

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		Input
object		Input
fields		Input

dim2mea

Dataflow Parameter	Conversion	Supported in Recipe
measureDefault		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		Input

export

Dataflow Parameter	Conversion	Supported in Recipe
source		Output (to .csv)
target
userId

filter

Dataflow Parameter	Conversion	Supported in Recipe
filter		Filter
saqlFilter		Filter (SQL filter expression) SAQL like operator may not be converted (depending on complexity) and isn’t supported. Use recipe Transformation custom formula with startsWith, endsWith, or contains.

flatten

Dataflow Parameter	Conversion	Supported in Recipe
include_self_id		Transform (Flatten)
self_field		Transform (Flatten)
parent_field		Transform (Flatten)
multi_field		Transform (Flatten)
path_field		Transform (Flatten)

prediction

Dataflow Parameter	Conversion	Supported in Recipe
predictionDefinitionName		Discovery Predict
predictionColumnName		Discovery Predict
predictionColumnLabel		Discovery Predict

sfdcDigest

Dataflow Parameter	Conversion	Supported in Recipe
object		Input
incremental
fullRefreshToken
fields		Input
filterConditions		Filter (Filter logic)
complexFilterConditions		Use Filter (SQL expression)

sfdcDigest

Dataflow Field Attributes	Conversion	Supported in Recipe
name		Input
defaultValue		Use Transform (Custom formula with case or coalesce)
type		Use Transform (Replace or Custom formula)
fiscalMonthOffset		Use Data Prep Date Configurations See Data Prep Fiscal Configuration
isYearEndFiscalYear		Use Data Prep Date Configurations See Data Prep Fiscal Configuration
firstDayOfWeek		Data Prep Date Configurations See Data Prep Fiscal Configuration
isMultiValue		Use Transform (Custom formula multivalue functions) See Multivalue Functions for Formulas
multiValueSeperator		Use Transform (Custom formula multivalue functions) See Multivalue Functions for Formulas
precision		Use Transform (Edit attributes) See Edit Attributes Transformation
scale		Use Transform (Edit attributes) See Edit Attributes Transformation

sfdcRegister

Dataflow Parameter	Conversion	Supported in Recipe
alias		Output
name		Output
source		Output
rowLevelSharingSource		Output
rowLevelSecurityFilter		Output

sliceDataset

Dataflow Parameter	Conversion	Supported in Recipe
source		Transform (Drop columns)
mode		Transform (Drop columns)
fields		Transform (Drop columns)

update

Dataflow Parameter	Conversion	Supported in Recipe
left		Update
right		Update
left_key		Update
right_key		Update
update_columns		Update