Filter By Row
Returns a table containing all rows from a specified table in which the values of specified columns matches the values in specified lists of values.
Arguments
This function has the following arguments:
Table: Table from which matching rows are to be extracted.
Filter Column Name: Text string that specifies a list of column names, the columns of
Table to be searched for matches. Separate column names with
Filter Value: Text string that specifies a
list of lists of values to be matched. Separate values with a coma. Separate lists with a semicolon (for example,
val1,val2;val3,val4;val5,val6). Enter
* for
Filter Value in order to display all rows in the table. To use
* as a literal comparative value, enclose it in single quotes. To use
; as a literal comparative value, enclose it in single quotes. If a filter value contains a space or a semicolon, enclose the entire value in single quotes.
A row from Table is included in the returned table if and only if the nthFilter Column Name matches a value in FilterValue’s nth list, for all n from 1 to the number of specified column names.
This function returns a table.