Different rows in one row per customer

[Anonymous]

Hi all,

In my database I have the following information:

Customer	Branche
Customer A	Branche X
Customer A	Branche Y
Customer B	Branche X
Customer C	Branche Y
Customer C	Branche Z

The problem I am facing is that I get multiple rows for a customer. So, what I would like to see is this:

Customer	Branche
Customer A	Branche X, Branche Y
Customer B	Branche X
Customer C	Branche Y, Branche Z

Is there any way to solve this:

1. In the sript?

2. In a chart?

Kind regards,

Henco

[jonathandienst · Accepted solution]

Henco

In script:

LOAD Customer,

     Concat(Branche, ',') As BrancheList

Resident Customers;

In a chart, very similar:

     Dimension: Customer

     Expression: Concat(DISTINCT Branche, ',')

Regards

Jonathan

[#3]

Hi,

please find the attached file...!

Regards,

Niranjan M.

[Anonymous]

Thanks a lot Jonathan!

Cheers,

Henco