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.
Copyright © 2013
Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or Terracotta Inc., San Francisco, CA, USA, and/or Software AG (Canada) Inc., Cambridge, Ontario, Canada, and/or, Software AG (UK) Ltd., Derby, United Kingdom, and/or Software A.G. (Israel) Ltd., Or-Yehuda, Israel and/or their licensors.