Transposing Table in SAP Hana

[Former Member]

I want to transpose row values from a table to column headings in SAP Hana. We can do it using Pivot function in SQL. But is similar function available in SAP Hana using SQLScript? If not, how can we get the desired output as shown in image here? Appreciate a detailed answer.

[former_member182302 · Accepted solution]

Hi Subrahmanya,

Have a look on the below :

Re: How to model scenario in HANA

From Column to ROW ( Opposite of what you'd require, but gives you an idea )

Regards,

Krishna Tangudu

[former_member226419]

Hi,

I have a small question. Are these line items are fixed or will change?

BR

Sumeet