How unpivot a table in LookML?

[hrucchetto]

I have a table with the following structure:

month | cost_cat1 | cost_cat2 | cost_cat3

But I need this one:

month | cat | cost

In other words I need to convert a wide table to a long one.

I tried using the UNPIVOT command from SQL but I got an error.

Can anyone help me with this issue?

Thanks in advance !!