Transpose data using CV in SAP HANA

[@gangadhar.1905]

Can we map from single projection multiple times by varying Calmonth values?

[@v3r0x]

And dynamic transposition ? What if you dont have fixed columns like months, but e.g. product variants that keep growing ?

[@Nachtaktiv2000]

till today there is no pivot or unpivot function in HANA, so we have to do such ugly workarounds 😕

[@DebanshuMukherjee]

There's Pivot / Unpivot available.. Just wait for my next video where I'll demonstrate the out of box pivot/Unpivot function

[@vijayabhaskart351]

can you explain it clearly by step by step in another video. Thank you.