Field values in 1 line

[#1]

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

.

[chriscammers · Accepted solution]

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

[awhitfield]

Hi there

Use the following

=Concat(sub-product,',')

Regards

Andy