Skip to main content
Salesforce

Return to Question

added 7 characters in body
Source Link
cown
cown
  • 1
  • 1

For example, I have a DE with some rows. And it looks like this

customer_name email 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

col1col2col3
123
252
334
145

and what "xyz" has received looks like this |col1 |col2 |col3 |------|------|---- |2 |5 |3 |2 |1 |1

col1col2col3
253
211

How can I do this?

For example, I have a DE with some rows. And it looks like this

customer_name email 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?

For example, I have a DE with some rows. And it looks like this

customer_name email 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

col1col2col3
123
252
334
145

and what "xyz" has received looks like this

col1col2col3
253
211

How can I do this?

added 5 characters in body
Source Link
cown
cown
  • 1
  • 1

For example, I have a DE with some rows. And it looks like this

customer_name email 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?

For example, I have a DE with some rows. And it looks like this

customer_name email 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?

For example, I have a DE with some rows. And it looks like this

customer_name email 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?

Source Link
cown
cown
  • 1
  • 1

Can I send an email to one person with several row of DE in SFMC?

For example, I have a DE with some rows. And it looks like this

customer_name email 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?