Note: The scenario below uses data from the DESelect Demo Data Package.
Scenario: You want to indicate the source of data you're loading into a target data extension by adding a new field that you want to populate with string 'DESelect Demo Data'.
Note: This scenario uses the feature Custom Values, which is available in DESelect Plus and Advanced.
1. Selection Criteria
On the selections overview screen, click on New to create a new selection.
Drag data extension DESELECT_DEMO_Contacts to the Selected Data Extensions section.
2. Target Data Extension
Hit the Create Data Extension button, enter a name, eg. Accounts with Source, and press Save.
Select the following fields by either double-clicking on them or dragging them to the section on the right:
- First Name, Last Name, and Email from DESELECT_DEMO_Contacts
- Drag Email again, and rename it to Source.
Click Save Data Extension.
Click on the Delete icon next to the Email field that's mapped to Source.
We have now created an extra field in our target data extension that we want to populate with 'DESelect Demo Data'. This field is not mapped to any fields in the source data extensions.
Now we're going to add the Custom Value:
- Under Custom Values on the left, click Add new value.
- Under Name, enter: Demo Data and hit Next.
- Choose Type: Fixed Value.
- For Field Type, choose: Text.
- For Value, enter Example Text.
- Hit Save.
Now that the custom value Demo Data has been created, we can map it to field Source by drag-and-dropping it from Custom Values to the Source mapping field.
When you click Run Preview on the Preview screen, a results table will be shown with fields
- First Name, Last Name and Email from DESELECT_DEMO_Contacts
- Source, populated with 'DESelect Demo Data'.
Note: This exact use case is very useful when you're loading data from different sources into the same target data extension using the tabs (append data extensions) functionality.
Please sign in to leave a comment.