Databases Reference
In-Depth Information
As you can see, the Transformation Step Wizard is split into several tabs, and each
one is used to handle different scenarios. We will be using three of the five tabs, but
will describe what all of them do and the types they could be used.
Throwing out the garbage
Our example file certainly has some garbage that needs to be thrown out. We will
use the first tab of the Transformation step wizard to:
• Remove the heading rows (first 4 lines)
• Remove the visual separator between the column headings and the
actual data
• Remove the weekly totals
Follow these steps to accomplish the above:
1. Click on each of the row numbers in the first four lines, as well as in the sixth
line, one at a time. The entire row should be highlighted and the
Delete
Marked
button should be enabled, as shown in the following screenshot:
