How to select cases of value that coincide with a column name?

How to select cases of value that coincide with a column name?

book

Article ID: KB0074225

calendar_today

Updated On:

Products

Statistica

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.

Issue/Introduction

How to select cases of value that coincide with a column name?

Environment

Windows

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"$).