topic Re: Merge two rows with one column with different values into 1 row with both values in App Development

Merge two rows with one column with different values into 1 row with both values

vanast — Thu, 30 Mar 2023 14:10:12 GMT

Hi,

I have the following issue. I have a set of data with multiple rows and different columns. I made a simple example that should solve my problem.

This is the example data that i have. If the values of ID is the same then i want to have a combined field in location separated by a value. How can i solve this in my script?

ID	Location
1	New york
1	Amsterdam
2	Tokyo
3	Barcelona

This is the table that i want to have

ID	Location
1	New york, Amsterdam
2	Tokyo
3	Barcelona

Thanks in advance for your help!

Re: Merge two rows with one column with different values into 1 row with both values

Or — Thu, 30 Mar 2023 14:11:47 GMT

This is a use case for Concat(), seemingly:

Load ID, Concat(Location, ',')

From YourTable

Group By ID;

Re: Merge two rows with one column with different values into 1 row with both values

vanast — Tue, 11 Apr 2023 07:27:32 GMT

Thank you for this. It worked!