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

rrsivaraghava · Post by **rrsivaraghava** » Thu Sep 18, 2008 6:09 am

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 · Post by **DS_SUPPORT** » Thu Sep 18, 2008 6:33 am

Search the forum for the keyword "Vertical Pivot", You can use Stage Variables to achive your requirement.

rrsivaraghava · Post by **rrsivaraghava** » Thu Sep 18, 2008 7:38 am

can u reply elaborately

chulett · Post by **chulett** » Thu Sep 18, 2008 7:46 am

Can you search first? Read the posts here on the pivoting technique, give it a try and then come back with specific questions.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 18, 2008 3:33 pm

rrsivaraghava wrote:can u reply elaborately

I doubt it. U has not even logged in for about three months.

rrsivaraghava · Post by **rrsivaraghava** » Wed Sep 24, 2008 7:46 am

where is the concept of vertical pivot.sorry i coulnt get ur solution....can u tell with proceure

rrsivaraghava · Post by **rrsivaraghava** » Wed Sep 24, 2008 7:48 am

where is the concept of vertical pivot.sorry i coulnt get ur solution....can u tell with proceure

chulett · Post by **chulett** » Wed Sep 24, 2008 7:55 am

Search. The. Forums. It has been fully explained ad nauseam here.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 24, 2008 3:06 pm

Ad nauseam as well. Enough times, indeed, almost to warrant an FAQ.

chulett · Post by **chulett** » Wed Sep 24, 2008 3:40 pm

D'oh! Fixed my typo.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 24, 2008 4:05 pm

chulett wrote:D'oh! Fixed my typo.

First declension: nausea, nauseam, nauseae (etc.)

tennetiharika · Post by **tennetiharika** » Thu Sep 25, 2008 4:49 am

use an aggregator stage

ray.wurlod · Post by **ray.wurlod** » Thu Sep 25, 2008 4:59 am

You could use an Aggregator stage if you like, but it won't produce the required output.