Grateful for any guidance. I'm seeing the syntax error below and I can't figure out why. New to MySQL Transforms as my previously relied upon python scripts are to be deprecated.
Objective
To take a single column of dates and turn them into column headers. Once pivoted, row value(s) are irrelevant (they'll be overwritten later).
Desired Result
Input Dataset
The MySQL Dataflow
/Dynamic Reverse Pivot/
CREATE PROCEDURE Pivot()
BEGIN
SET @sql = NULL;
SELECT GROUP_CONCAT(DISTINCT CONCAT('MAX(CASE WHEN dt = ''',dt,''' THEN ''',y,''' ELSE 0) AS ''', dt,''' ')) INTO @sql FROM preformat;
SET @sql = CONCAT('SELECT p.y,', @sql, 'FROM preformat p GROUP BY p.y');
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END
The Error
