Using unpivot in mysql with many columns
My Input looks like this: I want to see my output like : (I am trying to do unpivot in mysql data transform in Domo) Product Type , Date, Revenue A , 12-31-2015, 100 B,12-31-2015, 0 I am trying to use stored procedure: create PROCEDURE unpivot_cols() BEGIN SET @sql = NULL; SELECT GROUP_CONCAT(DISTINCT CONCAT('select…
