Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/03/2024 01:11 AM
Hello,
Is it possible to use advanced SQL Function to group lines into comma separated values like XML PATH ('') or STRING_AGG ?
For instance, I have a dataset "Test_Customer" containing id and names
Id | Name
01 | Tata
02| Toto
01 | Titi
The goal would be to obtain through an analytics a table that looks like this
Id | Names
01 | Tata, Titi
02| Toto
Is it possible ?
Solved! Go to Solution.
09/03/2024 01:25 AM
09/03/2024 11:16 AM
try
SELECT
Id,
GROUP_CONCAT(Name SEPARATOR ', ') AS Names
FROM
Test_Customer
GROUP BY
Id;