Pivot tasks missing from Bionic Participants in Advanced Outreach

  • 3
  • Idea
  • Updated 4 days ago
  • Implemented
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?
Photo of Seth

Seth, Employee

  • 14,544 Points 10k badge 2x thumb

Posted 7 months ago

  • 3
Photo of Abhishek Sivaraman

Abhishek Sivaraman, Senior Product Manager

  • 9,150 Points 5k badge 2x thumb
Hi Seth,

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

Abhishek S
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 13,270 Points 10k badge 2x thumb
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!​