Excluding a selected variable from concatenation

[nezuko_kamado]

I'm trying to make a column concatenating variables except selected one.

From the sample below, for example, when choosing apple from 'fruits', there should be a column concatenating the rest of fruits. Therefore,  banana, strawberry are concatenated for week1, and dragonfruit, durian, grapes, orange for week 2. But when select apple, the rest of the fruits for that week are gone, but only apple's showing

so the table should be look like below, if 'apple' gets filtered. 

week	selected fruits	rest of the fruits for that week
1	apple	banana, strawberry
2	apple	dragonfruit, durian, grapes, orange

mainTable:
load*inline [
week, num of pick, fruits, num, hrSum
1, 3, apple, 1, 200
1, 3, banana, 2, 200
1, 3, strawberry, 3, 200
2, 5, durian, 1, 500
2, 5, grapes, 2, 500
2, 5, apple, 3, 500
2, 5, dragonfruit,4, 500
2, 5, orange, 5, 500
3, 1, fig, 1, 100
4, 2, lemon, 1, 400
4, 2, gratefruit, 2, 400
5, 3, dragonfruit,1, 300
5, 3, gratefruit, 2, 300
5, 3, fig, 3, 300];

[marksouzacosta · Accepted solution]

Hi @nezuko_kamado,

Try this expression:

Concat(TOTAL <week> {<fruits = E()>} fruits,',')

Regards,

Mark Costa