Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
This is a use case for Concat(), seemingly:
Load ID, Concat(Location, ',')
From YourTable
Group By ID;
This is a use case for Concat(), seemingly:
Load ID, Concat(Location, ',')
From YourTable
Group By ID;
Thank you for this. It worked!