I have a sistuation were I can have multiple lrows for the same associates. The number of rows may very could be one could be 10. I need to combine all the rows into one using a specific format for the beneficiary. I have attached a sample of raw data and what I would nee the result to be. Any help would be appreciated.
See the example in attachment. This is done in the UI. You can use the same concat() technique in your script when creating a new table. In that case, add the GROUP BY clause.
BTW the output of concat() can be sorted differently by specifying a third parameter.
