Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi! Try something like
AggregatedTable:
Load
Position,
Concat(Name, ', ') as Name
Resident [Original Table]
Group by Position
;
Regards,
Jaime.
Hi! Try something like
AggregatedTable:
Load
Position,
Concat(Name, ', ') as Name
Resident [Original Table]
Group by Position
;
Regards,
Jaime.
Brilliant! Thank you much!