Relations between Data Extensions (DE's) are created by dragging one Data Extension on top of another in the Selected Data Extensions section.
Choose the field in the first Data Extension that matches the field in the second Data Extension. Usually, this will be an ID or Email address field.
In DESelect Segment, we call these the Matching Columns.
Choose an option In the dropdown in the middle. Below is a list of the available options for how the Data Extensions should relate to each other.
In DESelect Segment, we call these the Matching Types.
In SQL, these are the JOINS.
|
Name |
Description |
Example |
SQL Query |
|
A WITH/WITHOUT MATCHING B |
Match or don’t match DE A with DE B |
Returns a list of contacts (A) combined, whether or not they have a matching account (B) |
Left Join |
|
A WITH MATCHING B |
Only match DE A with DE B |
Return only the contacts (A) that have a matching account (B) |
Inner Join |
|
B WITH/WITHOUT MATCHING A |
Match or don’t match DE B with DE A |
Return all accounts (B) whether or not they have matching contacts (A) |
Right Join |
|
A WITH ALL B |
Match all of DE A with DE B |
Return all contacts (A) with all accounts (B) |
Full Outer Join |
|
A WITHOUT MATCHING B |
DE A without DE B |
Return the contacts (A) that don’t have a matching account (B) |
Left Join where B is a null value |
|
B WITHOUT MATCHING A |
DE B without DE A |
Return the accounts (B) that don’t have a matching contact (A) |
Right Join where A is a null value |
Comments
0 comments
Please sign in to leave a comment.