Databases Reference
In-Depth Information
6.
In the
Cell Condition
window, make sure the
Cell Value
field is set to
is empty
and the
Not
and
Case Sensitive
options are disabled. Click on
OK
twice to return to the
Transformation Step
window and see the result
so far:
As you can see, the missing cells now have the correct date value. Click on the
Next >
button to exit the
Transformation Wizard
.
From the
File Wizard: Option
dialog window, set the
Label
parameter to
Embedded
Labels
, and then click on
Finish
to generate the final
Load
statement.
The final result
After specifying the transformation criteria, the corresponding
Load
statement is
automatically generated and, as you will see, all of the settings are specified in the
script itself.