Convert into single cell - All values

Kumar252346 · Post by **Kumar252346** » Thu Jan 24, 2013 8:36 am

Hi,

I have data like below in the input,
ID,Email
1,a@gmail.com
1,b@gmail.com
1,c@gmail.com

And i want the output like below
ID,Email
1,a@gmail.com
b@gmail.com
c@gmail.com

That means i want all the emails in single cell and not in the single line.

We got this requirement to be done and we are trying for that.
Could some one suggest me please?

chulett · Post by **chulett** » Thu Jan 24, 2013 8:43 am

What have you tried? Looks like a vertical pivot to me with an extra step to contatenate the new columns into a single one, perhaps with a newline between them. Or if you are on 8.5 or higher, transformer looping.

prasson_ibm · Post by **prasson_ibm** » Thu Jan 24, 2013 11:12 am

For me it looks like interview question,it seems it has been asked same question to many people recently.

Kumar252346 · Post by **Kumar252346** » Mon Feb 04, 2013 6:47 am

But it came for me as requirement.This is not interview question.

Apart from this,whether it is requirement or question,there should be solution.

Could some on suggest please.

chandra.shekhar@tcs.com · Mon Feb 04, 2013 7:25 am

Looks like a vertical pivot to me with an extra step to contatenate the new columns into a single one, perhaps with a newline between them

I think Craig has given you the solution.