How to Split Row into columns through Data Stage?

sprasad55 · Post by **sprasad55** » Thu Apr 12, 2007 5:05 am

Can any one suggest me how to split row in to columns through data stage?

E.g
Row:
Column1 Column2 Column3
100 200 300

Into Columns:

Column1 Column2
100 200

Column1 Column3
100 300

Thanks

WoMaWil · Post by **WoMaWil** » Thu Apr 12, 2007 5:48 am

Welcome, there are several ways to do that depending on the kind of sourcefile.

for example Pivot-Stage or Hash Table or or or ....

Start searching in the Forum and if you don't find an answer to your problem, please let us know

chulett · Post by **chulett** » Thu Apr 12, 2007 6:58 am

Yep, as noted several ways. Simplest would be the Pivot stage unless you are working with a huge volume of data as it can be a little... slow.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 12, 2007 2:32 pm

The Pivot stage has its own manual (Pivot.pdf). Read that first, it contains good descriptions and examples.

georgesebastian · Post by **georgesebastian** » Fri Apr 13, 2007 3:49 am

WoMaWil wrote:Welcome, there are several ways to do that depending on the kind of sourcefile.

for example Pivot-Stage or Hash Table or or or ....

Start searching in the Forum and if you don't find an answer to your problem, please let us know

Hi Wolfgang,

By Hash Table do you mean a hash File?If so how can it do the functionality of a Pivot? Can you please explain..

Thanks
George

ray.wurlod · Post by **ray.wurlod** » Fri Apr 13, 2007 3:08 pm

Why?

A Pivot stage will do exactly what you require.

With a hashed file, the technique for a horizontal pivot is to load the non-pivoting columns in a value mark delimited dynamic array and to UNNEST that when extracting.

georgesebastian · Post by **georgesebastian** » Sat Apr 14, 2007 4:17 am

ray.wurlod wrote:Why?

A Pivot stage will do exactly what you require.

With a hashed file, the technique for a horizontal pivot is to load the non-pivoting columns in a value mark delimited dynamic array and to U ...

Sorry Ray,

I am not a premium member so i was not able to read your posting fully.
Sure i will be a premium member soon

Thanks
George