Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
concat(distinct Name, ';')
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.
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?
Thanks Steve . I tried using ID, Provider and Primary Name in dimension and kept Name in the expression. It worked.