We are using Data Relationships as a Data Filter to retrieve data from two data extensions, but the filtered data extension has fields only that of the source data extension. What must I do so that I have fields of both the data extension in the filtered data extension

1 Answer 1


Using a filtered data extension will only give you fields from the source data extension.

You have to create a standard data extension with the required fields you need in it. Then, you have to use SQL Query activity (in automation studio) to capture/filter data from 2 data extensions and put in the standard data extension. Use SQL JOINS to fetch data from 2 different data extensions.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .