topic need to get multiple field values into one row from multiple rows in App Development

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

Saritha077 — Mon, 20 Oct 2025 09:36:04 GMT

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 — Mon, 20 Oct 2025 09:54:44 GMT

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

Saritha077 — Mon, 20 Oct 2025 10:28:20 GMT

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

howdash — Mon, 20 Oct 2025 11:25:03 GMT

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]
;