Show columns in rows in a table

user00045
user00045
in Magic ETL

Hello, 

is it possible to show the columns in rows in a table card?? 

 

I have this…   
    
salesdiscountcostEbt
5000100030001000
100050800150
    
I wish that…   
    
sales50001000 
discount100050 
cost3000800 
Ebt1000150 

 

Thanks!!

Comments

  • guitarhero23
    guitarhero23 Contributor

    Using the ETL tool and using the Uncollapse Columns block may be of use. (See attached)

     

     

     


    **Make sure to like any users posts that helped you and accept the ones who solved your issue.**
  • ST_-Superman-_
    ST_-Superman-_ Coach

    I agree with @guitarhero23 

    Until we get access to those pivot tables that were unveiled at DP, I don't think you can do this without putting the data set through a Dataflow (ETL or MySQL).  

     

    Let us know if you would like help with the configuration.


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman

Categories