Concatenating same records

Thu, 31 Oct 2013 09:08:43 GMT

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

Re: Concatenating same records

Sokkorn — Thu, 31 Oct 2013 09:17:11 GMT

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