DSXchange

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

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

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.

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

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

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.

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