Skip to main content

I was sad to see that Pivot tasks are not available in Advanced Outreach's Bionic Query Builder.

There are several text fields that I want to concatenate together, and a Pivot task would make it easier (per the comments on this post).

Is there a reason that it was left out?

Hi Seth,

Thanks for sharing this. We will add this in the short term roadmap and prioritise this for advanced outreach.

Thanks
Abhishek S
Hi All, Admins can now use pivot tasks within the Query Builder as a Program’s Participant source.
Pivot tasks can reorganize and summarize selected data in an object to create a column for every data value.

To select a Pivot task open a Program model and navigate to the Participants step > + SOURCE > Query Builder > +TASK > select Pivot from the drop-down.

 Please refer the release notes for more information. 

Thanks for posting!​