Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
-
rrsivaraghava
- Participant
- Posts: 13
- Joined: Wed Feb 06, 2008 3:55 am
Post
by rrsivaraghava »
Input:
This is the input
No Name
1 Raghava
1 Rajiv
1 Ram
2 Suresh
2 Goutham
3 Vamsee
4 Bhima
Output
I should get this output
No Name
1 Raghava,Rajiv,Ram
2 Suresh,goutham
3 Vamsee
4 Bhima
-
DS_SUPPORT
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
Post
by DS_SUPPORT »
Search the forum for the keyword "Vertical Pivot", You can use Stage Variables to achive your requirement.
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Can you search first? Read the posts here on the pivoting technique, give it a try and then come back with specific questions.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
rrsivaraghava wrote:can u reply elaborately
I doubt it. U has not even logged in for about three months.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
rrsivaraghava
- Participant
- Posts: 13
- Joined: Wed Feb 06, 2008 3:55 am
Post
by rrsivaraghava »
where is the concept of vertical pivot.sorry i coulnt get ur solution....can u tell with proceure
-
rrsivaraghava
- Participant
- Posts: 13
- Joined: Wed Feb 06, 2008 3:55 am
Post
by rrsivaraghava »
where is the concept of vertical pivot.sorry i coulnt get ur solution....can u tell with proceure
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Search. The. Forums. It has been fully explained ad nauseam here.
Last edited by
chulett on Wed Sep 24, 2008 6:23 pm, edited 2 times in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
Ad nauseam as well. Enough times, indeed, almost to warrant an FAQ.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
D'oh! Fixed my typo.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
chulett wrote:D'oh! Fixed my typo.
First declension: nausea, nauseam, nauseae (etc.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
tennetiharika
- Participant
- Posts: 11
- Joined: Mon Feb 25, 2008 5:53 am
- Location: Hyderabad
Post
by tennetiharika »
use an aggregator stage
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
You could use an Aggregator stage if you like, but it won't produce the required output.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.