Values from one column "side by side" per ID

[#1]

Hello Qver,
there is a source table like
F1      F2
ID_1      A
ID_1      B
ID_1      C
ID_1      D
ID_2      B
ID_2      C
ID_2      E
ID_3      A
ID_3      D
ID_3      E
ID_3      M

Our users want as result
F1R      F2R
ID_1      A B C D
ID_2      B C E
ID_3      A D E M

I tried many things but to get that wanted result.
Can anybody help. Thanks + greetings > dj_skbs

[Sokkorn · Accepted solution]

Hi,

Try this

[Data]:
LOAD * INLINE [
F1,      F2
ID_1,      A
ID_1,      B
ID_1,      C
ID_1,      D
ID_2,      B
ID_2,     C
ID_2,      E
ID_3,      A
ID_3,      D
ID_3,      E
ID_3,      M];
QUALIFY *;
[Data2]:
LOAD
    F1,
    CONCAT(F2,' ')    AS [F2]
Resident [Data] Group BY F1;

HTH and let me know.

Regards,

Sokkorn Cheav

[SunilChauhan]

In dimension

take f1 and in expression

concat(F2,'  ')

hope this help

[#4]

Both answers (Sokkorn +  Sunil) are right in different ways.

But sorry I have only one possibility to confirm "right".

Thanks very much. dj_skbs