informix-datastage@oliver.com PIVOT
informix-datastage@oliver.com PIVOT
This is a topic for an orphaned message.
Bob,
There is a simple PIVOT stage that can be installed (its on the cd under
packages) which does this for you. Once install and mapped the output link column that is to contain the "months" data will have a derivation simular to this; Jan, Feb, March, .. where Jan, Feb, March are the respective column names to pivot. For each column in the derivation it will generate a new output row.
This is a very efficent stage and does not require any intermediate files or other exotic techniques.
Regards,
Allen Spayth
----- Original Message -----
From:
To:
Sent: Wednesday, April 25, 2001 3:13 PM
Subject: informix-datastage@oliver.com
> Greetings,
>
> I need to transform an input sequential file that has monthly
> amounts in comma, delimited format (likely a rolling 18 month maximum)
> to output records that will contain a single months data. So that 1
> input record will generate 18 output records. The date (mm/yyyy) for
> each month will
be
> found in a column header line at the beginning of the file and will be
> included on each fact record. Is there a good way to do this?
>
> Any help would be appreciated. By the way, Im using DS 4.0 on a
> Sun/Solaris server. Thanks, Bob
>
There is a simple PIVOT stage that can be installed (its on the cd under
packages) which does this for you. Once install and mapped the output link column that is to contain the "months" data will have a derivation simular to this; Jan, Feb, March, .. where Jan, Feb, March are the respective column names to pivot. For each column in the derivation it will generate a new output row.
This is a very efficent stage and does not require any intermediate files or other exotic techniques.
Regards,
Allen Spayth
----- Original Message -----
From:
To:
Sent: Wednesday, April 25, 2001 3:13 PM
Subject: informix-datastage@oliver.com
> Greetings,
>
> I need to transform an input sequential file that has monthly
> amounts in comma, delimited format (likely a rolling 18 month maximum)
> to output records that will contain a single months data. So that 1
> input record will generate 18 output records. The date (mm/yyyy) for
> each month will
be
> found in a column header line at the beginning of the file and will be
> included on each fact record. Is there a good way to do this?
>
> Any help would be appreciated. By the way, Im using DS 4.0 on a
> Sun/Solaris server. Thanks, Bob
>