I have a data extension with values like:
Email_Address | Job_ID | Date | Etc email@example.com | 1234 | 1/11/19 | etc firstname.lastname@example.org | 5678 | 1/11/19 | etc email@example.com | 9432 | 1/11/19 | etc
Using SQL, I want to pivot this flatten into a single row and have all Jobs as a string in 1 field :
Email_Address | All_Jobs firstname.lastname@example.org | 1234, 5678, 9432
My approaches so far of using the SQL Pivot function fails as an unsupported MC Function.
Any ideas how this could be done ?