Hello,

I have a datamodel with SQL where I tried to use unpivot function for BIP RTF table.

but below SQL is not working in order to achieve expected output. I mean I cannot even run it…

select line_num,unit_price, attribute_number1 from PO_LINES_DRAFT_ALL
unpivot (
splitl for years in (
line_num as 'column1',
unit_price as 'column2',
attribute_number1 as 'column3'
)
)
order by line_num
fetch first 6 rows only;

I would like to convert UNIT_PRICE, ATTRIBUTE_NUMBER1 rows values into columns as following

Can you please advise/help on this one?

Thank you!