Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have data like this in straight table:
| product | sub-product |
| A | apple |
| A | banana |
| B | book |
| B | pen |
i want like this :
| product | sub-product |
| A | apple,banana |
| B | book,pen |
how to do this,the sub-product should be in 1 line based on product with , seperator.
thanks in advance
.
Product would be your dimension and then you would create an expression for the sub-product field using the concat function. concat creates a delimited list of the values in a field.
Concat(Distinct sub-product,',')
I hope this helps.
Chris
Product would be your dimension and then you would create an expression for the sub-product field using the concat function. concat creates a delimited list of the values in a field.
Concat(Distinct sub-product,',')
I hope this helps.
Chris
Hi there
Use the following
=Concat(sub-product,',')
Regards
Andy