Page 1 of 1

Need to solve a small scenario which i couldn't get

Posted: Thu Sep 18, 2008 6:09 am
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

Posted: Thu Sep 18, 2008 6:33 am
by DS_SUPPORT
Search the forum for the keyword "Vertical Pivot", You can use Stage Variables to achive your requirement.

Posted: Thu Sep 18, 2008 7:38 am
by rrsivaraghava
can u reply elaborately

Posted: Thu Sep 18, 2008 7:46 am
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.

Posted: Thu Sep 18, 2008 3:33 pm
by ray.wurlod
rrsivaraghava wrote:can u reply elaborately
I doubt it. U has not even logged in for about three months.

Posted: Wed Sep 24, 2008 7:46 am
by rrsivaraghava
where is the concept of vertical pivot.sorry i coulnt get ur solution....can u tell with proceure

Posted: Wed Sep 24, 2008 7:48 am
by rrsivaraghava
where is the concept of vertical pivot.sorry i coulnt get ur solution....can u tell with proceure

Posted: Wed Sep 24, 2008 7:55 am
by chulett
Search. The. Forums. It has been fully explained ad nauseam here.

Posted: Wed Sep 24, 2008 3:06 pm
by ray.wurlod
Ad nauseam as well. Enough times, indeed, almost to warrant an FAQ.

Posted: Wed Sep 24, 2008 3:40 pm
by chulett
D'oh! Fixed my typo.

Posted: Wed Sep 24, 2008 4:05 pm
by ray.wurlod
chulett wrote:D'oh! Fixed my typo.
First declension: nausea, nauseam, nauseae (etc.)

Posted: Thu Sep 25, 2008 4:49 am
by tennetiharika
use an aggregator stage

Posted: Thu Sep 25, 2008 4:59 am
by ray.wurlod
You could use an Aggregator stage if you like, but it won't produce the required output.
:roll: