How to join different values based on same key

[jeevays7]

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

[dineshm030 · Accepted solution]

Hi,

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

Refer the attachment.

Hope this helps.