cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA View Row to Column Transpose

Former Member
0 Kudos

Hello Guys

What is the best way to transpose rows to columns within a Hana Model. I can find many articles that talk about Column to Row transpose.

Source:

CustomerDim 1Dim 2
1000A1100
1000B1200
1000C1300

Target:

CustomerABC
1000110012001300

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Guys

Any suggestions ?

Former Member
0 Kudos

Not as an answer, but as a question: Are there three rows *only* resp. could they be granted? Or you wanna have the amount dynamic, i.e. count the same customers and than created the amount of required columns?