Skip to main content
seth
Expert ⭐️
Mar 9, 2018 3:47 PM UTC

Pivot tasks missing from Bionic Participants in Advanced Outreach

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 ⭐️⭐️⭐️
    Mar 10, 2018 4:23 AM UTC
    Hi Seth,

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

    Thanks
    Abhishek S
    Translate
    sai_ram
    Expert ⭐️⭐️
    Oct 16, 2018 4:30 PM UTC
    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!​
    Translate