Acessing 1:n data from DB in a Campaign Delivery

Avatar

Avatar
Validate 1
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

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

Avatar
Validate 1
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

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

27-02-2019

Good morning,


I've been having a hard time since yesterday because I can't access the data that is in a one to many table in the database.Adobe problem.JPG

This is the case, I want to send a e-mail to an Employee, using data from one of the month and all the flights of that month.

So far I've not been able to find the data in a test preview as seen in the next images.

The code:

Adobe problem code.JPG

The result preview:

Adobe problem output.JPG

The data that I've found is the value of an external key (Unique Flight) in the employeeFlights Table.

Is it possible to access the full scope of data in the employeeFlights table to create a dynamic template that shows as many flights as there is entries in the table?

Note that the target mapping points to the Employees table not the Months table.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

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

Avatar
Validate 1
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

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

27-02-2019

I've found a way to do it the way I was expecting to do it.


Thank you

Answers (1)

Answers (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

982 likes

Total Posts

1,097 posts

Correct reply

517 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

982 likes

Total Posts

1,097 posts

Correct reply

517 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

27-02-2019

Hi,

For delivery personalization, select the many table into the temp table using query activity.

It has a wizard that will help pivot the rows into row-number-suffixed columns, e.g. select top 5 rows and in the row they'll be named flightNumber1..5, departureDate1..5, etc. From there use a loop counter to append 1..5 to the col names to access them.

Thanks,

-Jon