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

Inserting information into a worktable

Avatar

Avatar
Validate 1
Level 1
adamk81589338
Level 1

Likes

3 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
adamk81589338
Level 1

Likes

3 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
adamk81589338
Level 1

18-07-2018

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? (such as from the JavaScript or with SQL)

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
Adhiyan
Employee

20-07-2018

Hi Adam,

After you create the column by enrichment, you can write the data there using an expression or function using the advanced selection field.

Alternately you can also use a JS to write that into the temp table in the columns created.

xtk.session.Write(<query _operation="insert" _key="@id" col1="" col2="" xtkschema="temp:enrichment"/>);

Regards,
Adhiyan

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

18-07-2018

Hi adamk81589338 ,

You can use an Enrichment activity right after the Split and then Add new columns to the transition to feed data of choice.

Regards,
Vipul

Avatar

Avatar
Validate 1
Level 1
adamk81589338
Level 1

Likes

3 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
adamk81589338
Level 1

Likes

3 likes

Total Posts

6 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
adamk81589338
Level 1

19-07-2018

Thanks, I was looking at enrichment was wasn't entirely sure if it would do what I wanted. To clarify:

We can add new -empty- columns during the enrichment process, correct?

After adding the columns during the enrichment process. How do I feed data into the worktable? The best case for me would be to be able to feed from the delivery itself so I can enter data at the recipient level as its being evaluated. However, any suggestions here, or short examples would be very helpful.