DSXchange

Hi,

How do you achieve the following in a parallel job:

I have a source in the following format

Id Name

----- ---------

1 xx

1 yy

1 zz

2 xx1

2 yy1

2 zz1

3 xx2

3 yy2

3 zz2


I want to get the data in the target as following


id name1 name2 name3

----- -------- ---------- ----------------

1 xx yy zz
2 xx1 yy1 zz1
3 xx2 yy2 zz2

Are there any specific stage to do this.
Any help is highly appreciated.

Thanks

As your are on unix, if the data is going to have a consistent number of rows each time (e.g. in your example always 3 rows to be turned into 3 columns), the unix "paste" command will achieve this. Try the commnad "man paste" for an explanation.

David.

Thank You for your reply.The number of rows neednot be consistent.It just turned out to be like that in my example.

Hi,
Pls search for the topic "Vertical Pivot" in the forum

-Kumar

Read up on the Pivot Stage in your Ascential Documentation.

That would perform a Horizontal Pivot, basically the exact opposite of what the OP needs to do.

.

sorry(And Thanks) craig,

Note to self: Do not post just after getting up!!