When you have multiple sources with similar structures, you can combine and store them in the same Target Data Extension using the Append Data Extensions feature.
When do you need to use it?
When you have multiple sources of similar data. For instance, you have four Data Extensions with contact information (First Name, Last Name, Email), and want to create a new Target Data Extension to combine the data from these sources.
How can you do it?
- In case you have multiple sources of similar data that you want to append in the same Target Data Extension, you can do this by using different tabs: the Append Data Extension functionality in DESelect.
- Click on the + icon to create a new tab.
- Each tab can contain its own source Data Extensions/Data Views and filters.
- The data of the different tabs will be appended and written to one Target Data Extension.