need to get multiple field values into one row from multiple rows

[Saritha077]

Hi All,

I have data like below..

Product Name     product Locations

Shoes                     Hyd

Shoes                     Bangalore

Shoes                     Chennai

but i want get like 

Product Name     product Locations

Shoes                     Hyd,Bangalore,Chennai

while loading i need it.

Please help me to get this.

Thanks in advance.

[Amit_Prajapati]

Hi @Saritha077  , Try with Concat([product Locations],',') 

[Saritha077]

Thanks for your quick reply...Could you please help me to get while loading

[howdash]

You can use the concat() function in the script, but you will need to remember to use the Group By statement also. Like this:

tableName:

LOAD [Product Name],
    concat([product Locations], ‘,’) as [combined Locations

Resident someOtherTable

Group By [Product Name]
;