For example, I have a DE with some rows. And it looks like this
| customer_name | col1 | col2 | col3 | |
|---|---|---|---|---|
| abc | [email protected] | 1 | 2 | 3 |
| abc | [email protected] | 2 | 5 | 2 |
| abc | [email protected] | 3 | 3 | 4 |
| abc | [email protected] | 1 | 4 | 5 |
| xyz | [email protected] | 2 | 5 | 3 |
| xyz | [email protected] | 2 | 1 | 1 |
| mno | [email protected] | 2 | 3 | 5 |
| mno | [email protected] | 8 | 3 | 4 |
For now, if I send an email through Journey with this DE, every row has been sent. so that customer "abc" has received 4 mails for each row. (1,2,3) for first mail, (2,5,2) for second mail...
But what I want is each customer received just one mail with col1, col2, col3 For example, what "abc" has received looks like this |col1 |col2 |col3 |------|------|-- |1 |2 |3 |2 |5 |2 |3 |3 |4 |1 |4 |5
and what "xyz" has received looks like this |col1 |col2 |col3 |------|------|-- |2 |5 |3 |2 |1 |1
How can I do this?