Union AS on Export?

We have a page called time blocks. It has 6 columns: User, Date, Project1, Project2, Project3, Project4.

Technically it should be 3:
User, Date, Project
But it makes it more difficult for artists to at a glance see if they filled in all 4 time blocks for the day, so usability trumps database cleanliness.

But now we need to get it into excel for producer types to analyze and review.   Is it possible to have a JOIN export where we have like:
SELECT User,Date,Project1 AS "Project" FROM Timeblocks
SELECT User,Date,Project2 AS "Project" FROM Timeblocks

Is this possible to do?  I might need to just write a super basic Python exporter for them.


Please sign in to leave a comment.