Record structure to Omnis list structure

IT it at plastipol.com
Sat Apr 3 14:46:11 UTC 2021


Hi Doug,

Seems that crosstab function it's a true gem.

Thank you !


xavier

> El 1 abr 2021, a las 22:15, Doug Easterbrook <doug at artsman.com> escribió:
> 
> hi xavier.
> 
> this might help you.  it seems to describe your situation almost exactly.
> 
> https://stackoverflow.com/questions/41652740/convert-rows-to-column-in-postgresql
> 
> 
> 
> 
> Doug Easterbrook
> Arts Management Systems Ltd.
> mailto:doug at artsman.com
> http://www.artsman.com
> Phone (403) 650-1978
> 
>> On April 1, 2021, at 11:43 AM, IT <it at plastipol.com> wrote:
>> 
>> 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
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 



More information about the omnisdev-en mailing list