Data Extensions

Last Updated: 12/05/2018 Introduced in Version:

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 

  1. Start in the designer folders and navigate to System>Designers>Lookup Lists and Constants. Here, an action called “Add Data Extension” should be available.

Figure 1

 

2. Create a Data Extension. 

Figure 2

 

3. Under Input select Show Editor in the Properties Tab on the right and add the Flow Input Data to define the Data Definitions. 

Figure 3

 

4. In this example the data definition Name used is Accounts. Select close to save. 

Figure 4

 

5. Next, navigate to the Steps Tab and locate a Create Data Step. Under Favorites >Create Data and drag and drop on the flow designer.  Select Show Editor and add the Data for the Create Data Step.  

Figure 5

 

 

6. Add a Data Name and choose the Type. 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.

Figure 6

 

7. In the Merge Plain Text Editor add the Feilds that you wish to merge. In this example merge (Accounts. FirstName) and (Accounts.LastName).

Figure 7

 

 

8. The new Data Name will display in the Show Editor text box in the Properties Tab on the right.

Figure 8

 

 

Create a Flow

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

Figure 9

 

 

 

 

 

Additional Resources