Databases Reference
In-Depth Information
•
Path Name
: This is a string used to name a new field that will be created
containing the list of nodes from the top level to the corresponding node
•
Depth Name
: This is the name to be assigned to a new field that will hold the
number of levels for each expanded node
•
Path Source
: This is the field from the source table that contains the value
that should be used to populate the hierarchy path
•
Path Delimiter
: This defines the string that should be used to separate the
hierarchy values in the path
If any of the optional parameters are left blank, the new
field that uses the missing parameter will not be created
when expanding the hierarchy.
Even if none of the optional parameters are going to be used, the
Hierarchy
Parameters
checkbox should be marked for the script to be created, otherwise
it will not be generated.
We've also noted that, at the time of writing of this topic,
a bug in QV 11 SR2 build 11414 prevents the Depth field
(
HierarchyLevel
in the preceding example) from being
populated when using the wizard. Therefore, you may
need to manually modify the resulting script in order to
create the corresponding field, simply by adding the
Depth
parameter to the
Hierarchy
statement, as shown below.
After finishing setting the hierarchy parameters, click on
OK
to return to the
File
Wizard
window, and then click on
Finish
to generate the resulting
Load
statement.
The resulting script for our example will look like this:
HIERARCHY(Child_ID, Parent_ID, Child, ParentName, Child, Path, ' - ',
HierarchyLevel)
LOAD Parent_ID,
Child_ID,
Parent,
Child
FROM
[Hierarchy example.xls]
(biff, embedded labels, table is Sheet1$);