Magic ETL Dynamic Pivot

NateBI Member
edited January 2023 in Charting

Hi All,

Is this the only solution for dynamic pivoting? :

Hoping for a simpler solution.

Kind regards,


  • GrantSmith


    That's currently the only way to do a Dynamic Pivot. There isn't anything built into Magic that would allow you to do a pivot without previously knowing the values. You'd have to use a MySQL dataflow as documented in that article.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • NateBI

    Hi @GrantSmith , ok that's a shame but thank you!

  • RyanHartquist

    Is there already somewhere to upvote a dynamic pivot tile in magic ETL?? I would love to upvote that bad boy :)