Marge / concatenate the field data

[daniel_f]

Hi All,

How can I Marge / concatenate the data from a field horizontally like below example:

Now I have the data like that: (tablebox)

Order	Invoice
11111	12
	13
	14
22222	15
	16
	17
33333	18
	19
	20

And I want to transform the data like that (tablebox):

Orders	invoices
11111	12 ; 13 ; 14
22222	15 ; 16 ; 17
33333	18 ; 19 ;20

Which is the right function to flat the data?

Thanks in advance,

Dany

[Gysbert_Wassenaar · Accepted solution]

The concat function: concat(Invoice,' ; ') if used in a chart with Order as dimension.

Or in the script:

load Order, concat(Invoice,' ; ') as invoices

from ...mysource...

group by Order;

[daniel_f]

Thank you Gysbert, it was exactly what i needed !