Run Sub Data Flow - Data Flow Template Run Sub Data Flow - Data Flow Template

Run Sub Data Flow - Data Flow Template

Daiana Gallardo Daiana Gallardo

runsubdataflow.png

Overview 

This Data Flow template has two Data Operations that allow app builders to loop through a Data Flow. 

In Connection Builder, Data Flow templates can be found with pre-populated sample data. However, to meet the requirements of their Journey, app builders should perform the necessary adjustments, such as adding other Data Ops.

Basic Transform Operations

This Data Flow contains four main parts:

Inputs

The Start pane keeps track of the inputs required by the Data Flow. 

Run Data Flow Data Operation

  • Data Flow: no Data Flow selected
  • Asynchronous (non-sequential / don’t wait for results): box unchecked
  • Skip Data Flow (Entire): Airscript expression to skip running the Data Flow if TRUE
  • Run Multiple Data Flows: box unchecked
  • Inputs: num_times_to_run Variable of type Number - 1
  • Run Results:dataflow_output Variable of type Text that is automatically created to hold the results of this Operation.

Transform Data Operation

  • Transform Expression: Airscript expression to output text based on how many times the data flow is run.
  • Output Format: Variable
  • Type: Text
  • Run Results: transform output Variable of type Text that is automatically created to hold the results of this Operation.

Output

The End step is where variables from the Data Flow can be used as an output.

  • Sample Return Value: transform of type Text

Use Cases

  • Allow app builders to run a sub Data Flow in order to to run a Data Flow multiple times.