Flag rows on value

Flag rows from dataset that contain specific values by creating a column containing ‘1’ for all matching (in-range) rows. Unmatched rows are left empty.


Flag (output) column

Create a column in which to store the flag.


Apply the matching condition to the following:

  • A single column

  • An explicit list of columns

  • All columns matching a regex pattern

  • All columns


When applying the match condition to several columns (multiple, pattern, all), select whether the row will be considered as matching if all column match (ALL) or at least one column matches (OR).