Output to be concantenated & transposed

Analytics
Enthusiast

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

3 REPLIES
Enthusiast

Re: Output to be concantenated & transposed

You can use tdstats.udfconcat function.

Enthusiast

Re: Output to be concantenated & transposed

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

regards

RK

Enthusiast

Re: Output to be concantenated & transposed

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