We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

Reimplement Pivot nodes in new syntax



  • Official comment
    Tim Segall

    In terms of performance - the new node is dramatically faster.  In my brief testing typically 15 to 100 times faster.  For example, the new node processed 60 million rows in ~18 minutes.

    Comment actions Permalink
  • Avatar
    Adrian Williams

     A replacement node for the Pivot Data to Names node will be available in the 3.7.x release branch and, subsequently in the 3.8.x LTS branch. The replacement node does not utilize BRAINScript. The existing node will be superseded but will contine to be available and operate unchanged in these releases.

    The Pivot Names to Data node is already implemented using Java technologies and does not utilize BRAINScript. No changes are planned for this node at this time.

    While the Pivot Table node is implemented as a Composite library node, it does not expose BRAINScript to the user. It is likely that this node will be replaced by a new node in a future release, but the timeframe for this has not been confirmed at this time.

    The application currently provides the Transpose node, which is implemented using Java and can be used for a variety of simple data rotation use cases.


    Comment actions Permalink
  • Avatar
    M M

    Thanks for the update. I look forward to the new nodes.

    Comment actions Permalink

Please sign in to leave a comment.