Hi everyone,
I need to Traspose a table and i dont know if it is possible to do it.
I Attached a imagen. What i need to do is ID has to be only 1 line, Meta_Key has to be colums and meta_value in the correct column of each meta_key.
Thanks!
Regards
Gigio,
There's no transpose/unpivot step in Tableau Prep currently (though hopefully there will be something in a future release - in fact, you can add your support to this idea!)
Until then, here's a way that works in many cases: Unpivot in Tableau Prep (Rows to Columns) | VizPainter
Hope that helps!
Joshua
Thanks Joshua!
I had already thought about that idea but its not so efficent, its a shane that there is no way.
Because in the print i attached there are few metrics but in fact the real data base have almost 15 haha.
Regards!
Have a good day!