Skip to content
Advertisement

Create view with one row for each column in a table

I have a table that looks like this:

I need a view with 3 columns, that has a row for each column in the original table, so it would look like this:

The values on the currency column in the view need to be created by me (the EUR, JPY, etc) and are fixed values; I need to get the view rate from the first row of the original table, ignoring all other rows.

I’m stuck on this for a while now, and have no idea how I can solve this (did a lot of research but no joy). Can some one help me here? Thanks in advance!

Advertisement

Answer

The simplest approach, assuming you have another column we can order by (to identify which row is ‘first’) would be…

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement