Aggr data in the script

[Peony]

Hi all

I have a table  as in the examle below:

Position	Name
A1	Name 1
A4	Name 2
A1	Name 3
A4	Name 4
A2	Name 5
A2	Name 6
A4	Name 7

And Ineed to get the result such as below:

Position	Name
A1	Name 1, Name 3
A4	Name 2, Name 4, Name 7
A2	Name 5, Name 6

How to do shuch perfomance using loadscript?

[jaibau1993 · Accepted solution]

Hi! Try something like

AggregatedTable:
Load
    Position,
    Concat(Name, ', ') as Name
Resident [Original Table]
Group by Position
;

Regards,

Jaime. 

[Peony]

Brilliant! Thank you much!