String field

[rickrogers]

[Table2]:
Load
Cloth Type,
Req No.,
RESIDENT [Table1];

Is it possible to change the load statement above…

Cloth Type	Req No.
Linen	7369183
Linen	7369075
Linen	7368888
Linen	7200055
Cotton	7369036
Silk	7369173
Silk	7369169

…to make a new field named [Req No. String] that looks like this…

Cloth Type	Req No. String
Linen	7369183, 7369075, 7368888, 7200055
Silk	7369173, 7369169
Cotton	7369036

[Vegar · Accepted solution]

Try
[Table2]:
Load
[Cloth Type],
Concat([Req No.], ', ') as [Req No. String]
RESIDENT [Table1]
Group by [Cloth Type]
;