Grouping

[#1]

  Id   Val

1. A

  1    B

   2   A

   3   B

If I group By “ID”

Id     Val

1. AB
2. A
3. B

Is there a way I can group my  ID 2 and ID 3 also to VAL “AB” since they have at least  one value matching.

Suggestions ??

[#2]

Use this:

tmp:

LOAD *, Val as tmpVal INLINE [

    Id, Val

    1, B

    1, A

    2, A

    3, B

];

load Id,

    concat(tmpVal) as Val

resident tmp

group by Id

order by Id, Val;

drop table tmp;