Data Extensions
  • Updated on 05 Mar 2019
  • 1 minute to read
  • Print
  • Dark
    Light

Data Extensions

  • Print
  • Dark
    Light

Data Extensions are used to add Fields to a Data Structure . The Fields are defined on the Output and automatically added to the database or data structure specified in the Data Extension flow . The Data Extension allows the designer to make other calculations without running a flow every time and without having to save the specific field in the database.

Example

Start in the designer folders and navigate to System>Designers>Lookup Lists and Constants. Here, an action called "Add Data Extension" should be available.
2018-08-28_154257.jpg

Create a Data Extension. 
2018-08-28_154538.jpg

Under Input select Show Editor in the Properties Tab on the right and add the Flow Input Data to define the Data Definitions.
2018-08-29_105909.jpg

In this example the data definition Name used is Accounts . Select close to save. 
2018-08-29_105533.jpg

Next, navigate to theSteps Tab and locate a Create Data Step . UnderFavorites >Create Data and drag and drop on the flow designer.  Select Show Editor and add the Data for the Create Data Step.
2018-08-29_113246.jpg

Add aData Name and choose theType . In this example, the data name is Full Name and the Type is a String. Choose Merge Plain Text and then select Show Editor. then Close to save.
2018-08-29_114148.jpg

In the Merge Plain Text Editor add the Feilds that you wish to merge. In this example merge (Accounts. FirstName) and (Accounts.LastName).
2018-08-29_114512.jpg

The new Data Name will display in theShow Editor text box in the Properties Tab on the right.
2018-08-29_114733.jpg

Create a Flow

Now create a Flow that will fetch the new field names after they have been merged using theText Merge Editor. Start by navigating to the designer Folders and create aNew Flow. Locate a Fetch Entities Step, Integration>EntityFramework> FetchEntities Step.

2018-08-29_120242.jpg

Was this article helpful?