Databases Reference
In-Depth Information
Filling missing cells
As we previously said, there are records with no specified date. We will use the
Transformation Step Wizard
dialog to fill those values. Follow these steps:
1.
Activate the
Fill
tab from the
Transformation Step Wizard
dialog.
2.
Click on the
Fill…
button. The following wizard should appear:
3.
The
Target Column
field should be
1
, as that is where the date values
are stored.
4.
The
Fill type
will be
Above
, to take the value that is in the immediate
previous record.
5.
Click on the
Cell Condition…
button to specify which rows should be filled.