Dynamically Uncollapse Columns for Tabular Output

Try creating these two transorms in your data flow:

number 1:

CREATE PROCEDURE pivot()
BEGIN
set @sql_dynamic = (
SELECT
group_concat( DISTINCT
concat(
'max(case when month(Date)='
,month(`Date`)
,' and year(Date)='
,year(`Date`)
,' then EBProjectHealth end) as `'
,monthname(`Date`)
,' '
,year(`Date`)
,'`'
)
) as `test`
FROM `dojo_help_jlazerus`);

SET @sql = concat('create table pivot as ','Select ProjectName, ',
@sql_dynamic, '
FROM dojo_help_jlazerus
Group by ProjectName WITH ROLLUP'
);

PREPARE stmt from @sql;
EXECUTE stmt ;
DEALLOCATE PREPARE stmt;

END

number 2:

CALL pivot()

this will create a table named pivot that will pivot all of your months.

Did I get the field names correct?

I used "ProjectName", "Date", and "EBProjectHealth"

That's odd.  It works for me.  Does it error out when you run the Create procedure transform too?

Maybe I posted an old version of the code.  Try copying this in again?

CREATE PROCEDURE pivot()
BEGIN
set @sql_dynamic = (
SELECT
group_concat( DISTINCT
concat(
'max(case when month(Date)='
,month(`Date`)
,' and year(Date)='
,year(`Date`)
,' then EBProjectHealth end) as `'
,monthname(`Date`)
,' '
,year(`Date`)
,'`'
)
) as `test`
FROM `dojo_help_jlazerus`);

SET @sql = concat('create table pivot as ','Select ProjectName, ',
@sql_dynamic, '
FROM dojo_help_jlazerus
Group by ProjectName WITH ROLLUP'
);

PREPARE stmt from @sql;
EXECUTE stmt ;
DEALLOCATE PREPARE stmt;

END