HANA CDS AMDP Transpose Data from Row to Column

[D039507]

Hello,

with an SQL Script AMDP I want to transpose the data in the following way:

I have a data record:

But i need the data like this:

Has anyone an example or an idea how I can do this?

Thanks in advance

Thorsten

[KonradZaleski · Accepted solution]

You can achieve that using UNION clause:

SELECT "DIM", "Period1" AS "PERIOD" FROM YOUR_TABLE
UNION
SELECT "DIM", "Period2" FROM YOUR_TABLE
UNION
SELECT "DIM", "Period3" FROM YOUR_TABLE;

[KonradZaleski · Accepted solution]

If you want to keep duplicated values use UNION ALL instead.

[D039507 · Accepted solution]

Hi Konrad,

This is exactly what I was looking for, thank you so much! 😉

Best regards

Thorsten

[majik16 · Accepted solution]

konrad This was a lifesaver 🙂