I have a data column with syntax heterogeneity.
For example man is sometime written "Man" and sometime "man".
As spotfire is case sensitive, I have 2 categories in my pie chart or filter but I want to consider the 2 as a single category.
Is there a way to decide if a column must be subject to case sensitivity or not.
An alternative should be to create new column with "upper function" for example, but it's not ideal for me in this case.
Thanks by advance