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

Temporary data in personalization fields

Avatar

Avatar
Validate 1
Level 2
henrikl32515689
Level 2

Likes

2 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 2
henrikl32515689
Level 2

Likes

2 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
henrikl32515689
Level 2

26-02-2018

Hi Guys,

This is a great forum. So far, all my questions have received great answer. Thanks a lot

I am trying to figure out, if it is possible to insert temporary data in personalization fields e.g. from a file uploaded, but not saved in the tables.

Have anyone tried this and found a good solution?


Thanks

Accepted Solutions (1)

Accepted Solutions (1)

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

13-03-2018

Hi,

As Amit stated, you can do that by using an enrichment activity. For example, query your recipients, then place an enrichment activity connected to the query.

Now, add a file loading activity, and connect it to the enrichment activity as well.

In the enrichment, you can select which inbound set of data is the primary one (that would be the query one I guess), and create reconciliation conditions with the data coming from your file. Then select the columns from the file that you want to add to your recipient data.

All the additional columns will be available in the personalization fields of your delivery.

Amit's link is great for AC Classic.

If you are using AC Standard instead, or if you want a more comprehensive example of how it works event if you use AC Classic, please see the example in this page Adobe Campaign Help | Enrichment . The idea is basically the same for this simple example in AC Classic and AC Standard, even if the UI changes.

Hope this helps. Let us know how you do with that,

Florent

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 2
henrikl32515689
Level 2

Likes

2 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 2
henrikl32515689
Level 2

Likes

2 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
henrikl32515689
Level 2

13-03-2018

Thanks both of you for your input. It was exactly what I was looking for and the flow is now running perfectly.

Thanks

Avatar

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile
Amit_Kumar
MVP

27-02-2018

Hi,

This is possible and we do the same most of the time. Read this document for more details

Enriching data . The idea is quite simple to enrich your base query using additional data from list or file activity and add a column field1 with the data from your file and this data will be available as targetData.field1 in your query.

Regards,

AMit