Specify Row Condition

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.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?