Avatar

Community Advisor

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