concat and Aggr

[venkatg6759]

I have a straight table like this

ID                       Provider                 Name                        Primary Name

11                         Chase                   Bryan                             David

11                           Chase                  Amelia                             David

I need to get table like this

ID                       Provider                 Name                        Primary Name

11                       Chase                     Bryan;Amelia            David

Help me how to write the expression .I need to concat Name

Thanks,

Venkata

[Nicole-Smith]

concat(distinct Name, ';')

[#3]

Please create the straight table like below:

Dimension: ID

Expressions: Concat(Distinct Provider , ';')  Concat(Distinct Name, ';')  Concat(Distinct [Provider Name] , ';') 

You can't use concat inside aggr function for calculated dimensions.

[stevedark]

Why would you not have ID, Provider and Primary Name as dimensions and simply the Concat of the Name as an Expression?

I suppose, it depends on what should happen if there were multiple Providers and Primary Names within the same ID.  Would that be Chase; Other or two separate lines?

[venkatg6759]

Thanks Steve . I tried using ID, Provider and Primary Name  in dimension and kept Name in the expression. It worked.