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

Inserting information into a worktable

adamk81589338
Level 2
Level 2

I have a workflow that takes a group of recipients and spilts them into subsets, emails those recipients, and saves the temporary table with a ListUpdate so that we can associate the results of the tracking with individual segment codes. However, I need to save additional information during the workflow.

Specifically I need to associate more data per segment code that is not consistent between sends, (external_system_ids, specific variation codes, and a pre-personalized subject line). Is there any simple way to enrich the temporary table by INSERTING data directly into it from some bit of code provided from within the workflow?

After the Split, I would prefer to be able to turn this temporary worktable schema:

into this:

I would like to refrain from requiring some pre-created external table, since if that was required it would need to be recreated before every new campaign. Best case scenario would be something that could be saved into a specific templated workflow and then adjusted at a few points for the specific campaign.

TDRL: Is it possible to insert campaign specific information directly into a temporary worktable from the workflow?

1 Reply
pablo_rosero1
Level 10
Level 10

Hi Adam,

I believe that by making use of the Enrichment activity​ you should be able to achieve what you need.

Hope it helps!

All the best,

Pablo