All Forums Analytics
RanjaniKartik 9 posts Joined 09/14
29 Sep 2014
Output to be concantenated & transposed

Hello Gurus,
 
We are on TD14.0 and do we have any function that can derive the below o/p
 

Group

Product

1

A

1

B

1

C

2

B

2

D

 
I want to have the output as
 

Group

Prod_Lst

1

A,B,C

2

B,D

 
Thanks
Kartik

Raja_KT 1246 posts Joined 07/09
29 Sep 2014

You can use tdstats.udfconcat function.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

RanjaniKartik 9 posts Joined 09/14
30 Sep 2014

thanks .. do you have an example to show... i will parallely look into the doc as well
 
regards
RK

Raja_KT 1246 posts Joined 07/09
30 Sep 2014

I see that you got it from the other post. Right?
By the way, there are formatting options , when you want to format as "what you have " and "what you want as output"  I mean when you post your query

{...}Code

 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.