The Specify Row Condition dialog can be opened via the File Wizard : Transform dialog's Garbage page (the Conditional Delete button), the Column page (the New... button) or the Unwrap page (the Conditional Unwrap button). Here it is possible to define a logical condition for selection of one or several rows. Depending on the context the rows that are defined are either deleted, copied to a new column and split the table in several parts.
In the Condition group it is possible to specify a condition where a column equals a specific value or another column, a range of records or all records. Several conditions can be applied together. After defining a condition press the Add button to include it in the transformation.
- Compare with value: Matches the cell with a cell condition that can evaluate to true or false.
- Compare with column: Matches the cell with the corresponding cell in another column.
- Range: Selects x rows, then skips y rows. Starting and ending positions for this may be specified with indexes.
- All Rows: Use this condition if all rows should be selected.
- Column: Sets the column number on which the condition should be applied.
- From: Only visible in Range mode. Sets the row number from which rows should be deleted or a second condition should be applied.
- To: Only visible in Range mode. Sets the row number to which rows should be deleted or a second condition should be applied.
- Select: Only visible in Range mode. Here it is possible to set whether rows should be selected or skipped cyclically, e.g. cyclically select two rows, then skip one. If all rows should be used, Select should be set to 1 and Skip should be set to 0.
- Options: In this subgroup it is possible to specify modifiers
for the selection.
- Case Sensitive: Enable this option if comparisons should be case sensitive.
- Not: Enable this option if the selection criteria should be inverted.
- Conditions (AND): In this group the conditions specified
and included in the transformation are seen. A
logical AND is applied between conditions.
- Add: Adds the current condition to the list.
- Remove: Removes a selected condition from the list.
