Question Re: SQL Transpose rows to columns in Technology Q&A

SQL Transpose rows to columns

former_member182343 — Tue, 20 Oct 2020 04:13:40 GMT

Hi All,

I need to convert rows to columns as per below requirement.

Can anyone help with SQL in HANA .

Thanks in advance.

Re: SQL Transpose rows to columns

former_member358098 — Tue, 20 Oct 2020 06:42:08 GMT

Hello.

Something like this ?

select distinct order,
item,
sequence,
(select costcenter from <table> where order = <alias>.order and item = <alias>.item and sequence = <alias>.sequence and position = 'A1') CostCenterPosA1,
(select costcenter from <table> where order = <alias>.order and item = <alias>.item and sequence = <alias>.sequence and position = 'A2')CostCenterPosA2,
(select costcenter from <table> where order = <alias>.order and item = <alias>.item and sequence = <alias>.sequence and position = 'A3')CostCenterPosA3
from <table> <alias><br>

Re: SQL Transpose rows to columns

KonradZaleski — Tue, 20 Oct 2020 09:22:06 GMT

Hi Vijay,

Please check the existing thread on sap community. There is very similair scenario described so you could adjust the logic to your requirements.