Record structure to Omnis list structure

[IT]

Hi,


I have a select from postgres database that returns records with item properties. Every record is a single propertie.

Something like this:

item_sku   car_name   laca_value   unca_simbol
36102        Lenght         490             mm
36102        Width          300             mm
36102        Height         200             mm
36102        Weight         1,1             kg
36102        Colour         Red            NULL
36103        Lenght         500             mm
36103        Width          300             mm
36103        Height         225             mm
36103        Weight         2,0             kg
36103        Colour        Blue            NULL
36104        Lenght         600             mm
36104        Width          350             mm
36104        Height         225             mm
36104        Weight         2,5             kg
36102        Colour        Grey            NULL


I need to convert records structure in a table.
Extract title columns, and item values to an omnis list 

I need an Omnis list with something like this.

SKU     Length(mm)     Width(mm)     Height(mm)     Weight(kg)     Colour
36102   490            300           200            1,1             Red
36103   500            300           225            2,0             Blue
36104   600            350           225            2,5             Grey

The number of properties varies based on product lines. 


Any advice ?

regards

xavier