Forum Discussion
SQL code
hi All,
I need SQL code for below issue
I have two table as shown below
| Id | Name |
| 1 | Roy |
| 1 | Roy |
| 1 | Roy |
| 1 | Roy |
| 1 | Roy |
| Name | Type |
| Roy | GE |
| Roy | RA |
| Roy | SA |
| Roy | PA |
| Roy | PA |
These two have primary key as Name.
Desired Output
| Id | Type |
| 1 | GE,RA,SA,PA |
kindly need help
Anonymous,
Use String_Agg if you use T-SQL: https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-ver15
Anonymous
A dedicated forum might be more appropriate. In DAX, you may use CONCATENATEX to add a measure.
https://community.powerbi.com/t5/Desktop/split-by-delimiter/td-p/363277
2 Replies
Anonymous,
Use String_Agg if you use T-SQL: https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-ver15
Anonymous
A dedicated forum might be more appropriate. In DAX, you may use CONCATENATEX to add a measure.
https://community.powerbi.com/t5/Desktop/split-by-delimiter/td-p/363277