SQL code

[Anonymous]

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 · Accepted solution]

@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

[v-chuncz-msft · Accepted solution]

@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

[Anonymous · Accepted solution]

@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