Databases Reference
In-Depth Information
Unwrapping table contents
There is another "formatting challenge" we will tackle with this file, which is,
that data is split into two parts: the first five weeks are on the left side of the
file and weeks 6 - 10 are on the right, occupying the same rows. So, we need
to unwrap them.
Essentially, we want to move the data located on the right part of the table and place
it below the data located on the left. To do that, we will activate the
Unwrap
tab from
the Transformation Step wizard and follow these steps:
1.
Use the bar-shaped cursor to mark the beginning of the "right" part of the table
by clicking on the column border between columns 4 and 5. This will specify
the separation, as seen in the following screenshot. If you don't see where the
second part of the table begins, use the scrollbar to move to the right.
