Talend ETL how to concatenate strings during group by / aggregate operations taggreraterow

Problem - you have multiple rows for same group key but these rows has some string column which you want to get into your processing but want to concatenate this column values for same group key rows into one. example you have data in your table that tells a product is shippable at what locations
ProductName ShipLocation
Prod_01       IND
Prod_01       US
Prod_01      CA
Prod_02    UK
.....

You need a result like
Prod_01 IND;US;CA
Prod_02 UK

Solution - input the rows into tAggregateRow and group by ProductName. In the output Column select shipLocation and in function use LIST and input column position again select shiplocation.
(make sure you increase size of your output shiplocation column in schema)
in the advance settings for tAggregateRow you can use delimeter as ;.
when you take output from this tAggregateRow it returns the output as desired (semicolon separated and concatenated for each group key)