SECTION# returns a string containing the section with corresponding parameter values (and names) of two Telitab sets
SECTION#(Telitab_1$, UnfoldPar_1$, Telitab_2$, UnfoldPar_2$, Mode%)
Arguments
Telitab_1$ is a string expression containing/returning the first Telitab set.
UnfoldPar_1$ is a name of parameter for which to unfold the first Telitab set, see also the UNFOLD#() function.
Telitab_2$ is a string expression containing/returning the second Telitab set.
UnfoldPar_2$ is a name of parameter for which to unfold the second Telitab set.
Mode% provides options how to return the result
Mode% = 0 returns the section containing only the parameters present in both the sets of section cases.
Mode% = 1 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: Functions overview | Attribute overview | Constants overview | Dimensions overview