My hunch here is that it’s complaining because you can’t set a column name with a digit as the first letter, which is going to happen since you’re pivoting on a date column. Maybe try creating a new sub query that appends something like “d2020-04-01” and then pivoting on that?
1 Like