“Filter out cases from a record set using everything from simple blank replace to complex expressions.”
Validates data based on the expression supplied. If the validation fails, the step will throw an exception.
Expression - Groovy expression to be used for the validation. e.g. Name.isEmpty() or Name.equals(‘John’)
The filter will only pass down records when the specified columns compare successfully with the given value.
Columns - The list of column names to be compared.
Operation - The type of comparison to perform.
Value - The value with which the columns will be compared.
The filter will pass down all the records which meet the expression criteria.
Expression - Groovy expression to be asserted. e.g. TradeId.isEmpty()
The filter will pass down all the records which fall in the specified range.
First Row - The first accepted row (counting from 1).
Last Row - The last accepted row.
The filter will only pass down records in which the specified columns are not blank and not null.
Columns - The list of column names to be checked.
In the examples which are bundled with ORQA, you will see “04. Filtering Data” directory where you will find more examples.
Learn about other ORQA operations