Concatenating same records

[#1]

Hi Everybody,

I have a view that contains records like below,

BondApplicationNo               CustomerName

216953766                               MAEPA, SEBOLELA DORAH

216953766 MAEPA, TEBOGO REGINALD

216972167                               ROACH, WAYNE

I want to concatenate the CustomerName whenever the BondApplicationNo is the same and return 1 record like below,

BondApplicationNo               CustomerName

216953766                               MAEPA, SEBOLELA DORAH  l  MAEPA, TEBOGO REGINALD

216972167                               ROACH, WAYNE

The BondApplicationNo can have more that 2 CustomerName associated with it ( incase of a joint Bond of 3 or more people).

Please help. Thanks

[Sokkorn]

Hi,

Concat() function should do this job. Let try with two options below:

1. Create straight table with

     a. Dimension: BondApplicationNo

     b. Expression: Concat(CustomerName,' | ')

2. Or use in load script

     Load

          BondApplicationNo,

          Concat(CustomerName,' | ')     AS [CustomerName]

     From TableName Group By BondApplicationNo;

Regards,

Sokkorn