Forum Discussion
Solved
Clean duplicate words in a string using CONCATENATEX funciton
Hi. I have a issue trying to concatenate strings. My model contains 2 tables: Product and Component. Each product is built up by 2 or more components. Each component contains a label. For...
aramirez2 you can use a measure like this
Measure = CONCATENATEX ( VALUES ( Component[LABEL] ), Component[LABEL], ",", Component[LABEL], ASC )If you need a calculated column
Column = CONCATENATEX ( SUMMARIZE ( RELATEDTABLE ( Component ), Component[LABEL] ), CALCULATE ( MAX ( Component[LABEL] ) ), ",", Component[LABEL] )
Thanks amitchandak
Your formula is running now but the result is not as expected. There are still duplicated words as at the beginning: "green-green-blue".
My model contains two tables:
- Table Product with only ID column. Furthermore I want a new column "Label" which should concatenate all their components labels.
- Table Component with 3 columns; PRODUCT_id, COMPONENT_id and LABEL (as my previous table example)
So expected Product table result is:
| ID | Label |
| A | green-blue |
| B | green-red |
Thanks for your time
aramirez2 you can use a measure like this
Measure =
CONCATENATEX (
VALUES ( Component[LABEL] ),
Component[LABEL],
",",
Component[LABEL], ASC
)
If you need a calculated column
Column =
CONCATENATEX (
SUMMARIZE ( RELATEDTABLE ( Component ), Component[LABEL] ),
CALCULATE ( MAX ( Component[LABEL] ) ),
",",
Component[LABEL]
)