Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Create colums in a workflow

Avatar

Avatar
Validate 1
Level 2
andrea99471644
Level 2

Likes

4 likes

Total Posts

2 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
andrea99471644
Level 2

Likes

4 likes

Total Posts

2 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
andrea99471644
Level 2

17-11-2017

Hello,

I have an issue: I constructed a workflow that chose the most bought products and gives 6 products with its ids and prices.

ProductidNAMEPrice
1Product12
2Prduct29
3Product311

On the same worklflow I have a query with the customers I want to target that gives me a table like:

NameidNameEmailAddress
12blabla@hol.com
56blablablab@zughdd.com

I want to make a dynamic email so I would need to create a target like this:

NameidEmailAddressProduct1Product1priceProduct2Product2price
12blabla@hol.comProduct12Prduct29
56blablablab@zughdd.comProduct12Prduct29

Can you tell me how please?

Thank you in advance,

Andrea

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 2
andrea99471644
Level 2

Likes

4 likes

Total Posts

2 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
andrea99471644
Level 2

Likes

4 likes

Total Posts

2 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
andrea99471644
Level 2

04-12-2017

Hello,

Thank you both for your answers

What I wanted to do was indeed to send a list of the most bought products to a list of recipients, but that list was calculated automatically each time my workflow ran; but the problem was that the two pieces of information were in different schemas. I was finally able to do it by Intersecting both on a column that they were sharing (an id).

Thank you,

Andrea

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 2
Marjorie59270
Level 2

Likes

8 likes

Total Posts

33 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
Marjorie59270
Level 2

Likes

8 likes

Total Posts

33 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
Marjorie59270
Level 2

04-12-2017

Bonjour Andrea !

J'ai fait a peu près la même chose dans un de mes workflows. Pour se faire, j'ai rajouté un numéro de ligne. Ensuite, j'ai rajouté un branchement. Puis, j'ai sélectionné mes lignes une à une avec une boîte de partage. Enfin, j'ai rajouté un enrichissement pour chaque produit (1,2,3,...)  avec un libellé de colonnes "libelle_produit1" et en alia "@lb1" par exemple.

Pour être plus claire voici la partie de mon workflow qui gère cela :

1365352_pastedImage_1.png

Attention ! Vous devez connaître le nombre maximum de produit que vous pouvez obtenir.

En espérant avoir aidée,

Bonne fin de journée,

Cdt,

Marjorie

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

04-12-2017

Hi Andrea,

Sorry for the delayed answer, I missed your question.

Can you tell me what's the final goal of your workflow? Looking at what you described, it looks like you want to send a list of the most bought products to a selection of recipients. If that is the case, you can probably enrich your recipient targeting with the product data. This type of additional information is known as "collection" in Campaign.

If you are using ACS, you can do this with the Query activity, see Adding a collection here: Adobe Campaign Help | Query .

If you are using ACC (v6 or v7), you can do this with a Query or an Enrichment activity, see Adding a data collection here: Targeting activities .

Hope this helps,

Florent