How to remove all the column evaluation_taste

Audit_CKGoC · 11-24-2021 06:19 PM

Aurelien

Here:

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

Audit_CKGoC

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

Aurelien

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 ?

Audit_CKGoC

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.

Aurelien

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

Audit_CKGoC

You’re a beast. Thanks a lot

Aurelien

You are welcome

Steve

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(""))