Magic ETL Dynamic Pivot

NateBI Member
edited January 26 in Charting

Hi All,

Is this the only solution for dynamic pivoting? :

Hoping for a simpler solution.

Kind regards,


  • @NateBI

    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!**
  • Hi @GrantSmith , ok that's a shame but thank you!

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