SECTION# returns a string containing the section with corresponding parameter values (and names) of two Telitab sets
Arguments
is a string expression containing/returning the first Telitab set.
is a name of parameter for which to unfold the first Telitab set, see also the UNFOLD#() function.
is a string expression containing/returning the second Telitab set.
is a name of parameter for which to unfold the second Telitab set.
provides options how to return the result
returns the section containing only the parameters present in both the sets of section cases.
returns the section containing all parameters in both the section cases.
Before explaining the SECTION function, some words on unfolding a Telitab set for a particular parameter. Unfolding implies that the record(s) containing this parameter are moved to the top of the hierarchy.
So if Telitab_1$ contains the dataset:
To explain the data:
you have two objects, MODELS and PROJECTS presented as list values in Telitab_1$ containing TeLiTabs themselfs (with several parameters).
LPP is part of the MODELS object (TeLiTab).
When you unfold Telitab_1$ dataset on parameter "LPP", you get:
You see that PROJECT still is a separate object (and presented as a list value in Telitab_1$). All other data (which was part of the MODELS object) now is part of Telitab_1$ and thus a table in the TeLiTab.
To unfold a Telitab set for a particular parameter implies that the record(s) containing this parameter are moved to the top of the hierarchy. If UnfoldPar$ = "NullString", no unfolding is performed.
The section should be performed on two Telitabs, so,
Telitab_2$ contains the dataset:
and UnfolPar_2$ contains "NullString", so no unfolding is performed
Now the actual section is created using the following syntax:
and it returns:
Please note that using Mode%=0 means that the section is returned casewise (per row) and case parameters not present in both sets like "MODNO$", "MODMAT$" and the object "PROJECT" are not in the returned result.
If these parameters should be also in the result, use Mode%=1, so for the above argument values,
returns:
The SECTION#() function with Mode%=1 can be used as a special query function. The section of two Telitab sets produced by this functiun completes a set of data by combining data from two source sets in a single table (see also UNION#()).
Quick links: Function overview | Attribute overview | Constants overview | Dimensions overview