How to join different values based on same key

jeevays7 — Wed, 23 Nov 2016 07:05:04 GMT

Hi all,

I have data like this,

ID Name

1 A

1 B

1 C

2 A

2 B

3 A

how to join different values based on same ID.

I need the result like below:

ID Name

1 A/B/C

2 A/B

3 A

Re: How to join different values based on same key

dineshm030 — Wed, 23 Nov 2016 08:53:35 GMT

Hi,

Here we cannot use the join. We have to use concatenate functions in the script.

Refer the attachment.

Hope this helps.