How to remove all the column evaluation_taste

image

Hi @Audit_CKGoC

Here:

Picking a specific list will display only those picked.
Picking none will be similar to picking “All Other Columns”

1 Like

I want to remove All the comma in the column evaluation_taste rather.

OK.
I assume this column is an expression that results in a list.
If so, you may want to wrap the expression that provides this list, into a UNIQUE() expression.
For reference:

Can you confirm ?

1 Like

yes you’re right. but the problem here is even though the column is blank, it still show a comma and we have a bot that only triggers when this column is empty.

OK, then try:
UNIQUE([yourPreviousExpression])-LIST("")

1 Like

You’re a beast. Thanks a lot

2 Likes

You are welcome :slight_smile:

1 Like

Note that list subtraction has the side-effect of removing duplicates, so the use of UNIQUE() here is redundant. This will accomplish the same thing:

([yourPreviousExpression] - LIST(""))

See also:

1 Like