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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Temporary data in personalization fields

henrikl32515689
Level 2
Level 2

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

1 Accepted Solution
florentlb
Correct answer by
Level 10
Level 10

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

View solution in original post

3 Replies
Amit_Kumar
Community Advisor
Community Advisor

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

florentlb
Correct answer by
Level 10
Level 10

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

View solution in original post

henrikl32515689
Level 2
Level 2

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

Thanks