Magic ETL Dynamic Pivot

NateBI
NateBI Member
edited January 2023 in Charting

Hi All,


Is this the only solution for dynamic pivoting? :

https://domo-support.domo.com/s/article/360042923454?language=en_US

Hoping for a simpler solution.


Kind regards,

Answers

  • GrantSmith
    GrantSmith Coach

    @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!**
  • NateBI
    NateBI Member

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

  • RyanHartquist
    RyanHartquist Member

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

Categories