Skip to main content
seth
Expert ⭐️
March 9, 2018

Pivot tasks missing from Bionic Participants in Advanced Outreach

  • March 9, 2018
  • 2 replies
  • 46 views

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?

    2 replies

    abhishek_sivaraman
    Helper ⭐️⭐️⭐️
    March 10, 2018
    Hi Seth,

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

    Thanks
    Abhishek S
    sai_ram
    Expert ⭐️⭐️
    October 16, 2018
    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!​