How to select cases of value that coincide with a column name?
Article ID: KB0074225
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 12.7 and higher |
Description
This article shows the instruction to select cases of value coincident with another column name in the spreadsheet.
For instance, in an example data with two columns called "Name" and "Product" as shown below, the last case under the first column "Name" has a text value equal to "Product", which is coincident with the second column name in the spreadsheet.
Environment
Resolution
When specifying the expression of selection condition, append a $ to the end of a text string to indicate it is a string literal and not a variable name, e.g., "text"$.
In the example described, in order to select/return the case with variable "Name" equivalent to text "Product" (i.e. the last case in the spreadsheet), you can use expressions with conditional functions such as:
"Name" = "Product"$;
or IN ("Product"$, "Name")=1;
or Contains ("Name", "Product"$).
Issue/Introduction
Feedback
