SQL Transpose rows to columns

[former_member182343]

Hi All,

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

Can anyone help with SQL in HANA .

Thanks in advance.

[former_member358098]

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>

[KonradZaleski]

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.