Databases Reference
In-Depth Information
2.
Click
Unwrap
to move the table content to the appropriate place. We should
now see the following result:
The preceding procedure leaves us with a new garbage line: the column
headings corresponding to the unwrapped content (shown at line 27 in the
preceding screenshot). To remove it, we need to go back to the
Garbage
tab
and follow these steps:
3.
Click on the
Conditional Delete…
button to specify the condition on which
the rows should be removed.
4.
From the
Specify Row Condition
dialog window, we will specify two
conditions, joined with an
AND
operator. For the first condition, mark the
following parameters:
° The
Compare with value
radio button should be selected
° The comparison operator will be set to
contains
° The comparison value will be the word
Date
° The
Case Sensitive
and
Not
options should be disabled