Representative Creater - concatenate records

Hi 😇,

You should be able to do the above in Representative Creator.

Define for column “accumulated”, the expression:

concatenate(purchased)

If your input is:

customer  purchased

0000001   shoes

0000001   belt

0022222   pants

0022222   jacket

0022222   pants

Then the output would be:

customer  accumulated

0000001    shoes belt

0022222    pants jacket pants

If you still want the accumulated to show each value only once (i.e. have a distinct operation on it), you can use the expression:

distinct(concatenate(purchased))

Space character is used as default separator. If you wanted a different separator (e.g. |), use expression concatenate(purchased,’|’)

Hope this helps?

Thanks,

May