Page 1 of 1

rows to colums using pivot stage

Posted: Wed Mar 29, 2006 11:47 pm
by ramsdanda
Hi ,

Anybody help me regsrding Pivot stage , my requrement like this i need to interchnage rows to coloums.

Ex: input is like A, Card1,100
A,Card2,200
A,Card3,300

My out should be like this A,Card1,Card2,Card3
100, 200, 300 (data) can u please help me how implement logic using pivot stage . plese treat it as very urgent.

Thanks&Regards
Ramesh

Posted: Wed Mar 29, 2006 11:52 pm
by rasi
First do a search on the forum for Pivot....

For Urgent you need to hire consultant immediately...In DSXchange urgent = ignore

Posted: Thu Mar 30, 2006 2:19 am
by kumar_s
This cannot be acheived by PIVOT stage. But by search.

Posted: Thu Mar 30, 2006 2:32 am
by ray.wurlod
A good search topic would be vertical pivot. Several techniques exist.