Hi Gurus,
please help us to achieve this requirement.
Our database table stores model related attributes in Key-Value pair. we want to transpose the data and display model attributes as per traditional relation database structure of single row data.
example data :
select model_number, attribute_name, attribute_value from xxcmst_inv_cmt_product_iface_stg where model_number = 'MODEL123';
the requirement is to write the select clause in such a way to transpose the result set into a single row as shown below :
it will always be run for a single model which has unique captions. so resultant set will always be 1 row.
Regards,
Samir Kumar Das