Source Data
This function analyses the values in a selected column or row to determine if there are missing values in the hierarchy. Only relevant for “Outline Id” and “Delimited Path”. Please refer to the section “Outline Structures in Excel Data” in the chapter “Concepts Behind TreeWiz” above for more information about outline levels in source data.
Key Steps
To check the outline structure using your table data, follow the steps below.
Step # |
Step Detail |
---|---|
1 |
Select the column or row that contains the outline structure source data that you want to check. |
2 |
Click on the “Check Outline Structure” button in the TreeWiz Ribbon Menu in the Tools section |
3 |
Edit the parameters in the Parameters Form that is activated |
4 |
Click on “OK’ to perform the function or “Cancel” to exit |
5 |
The function will perform |
6 |
Click on “Cancel” or the form close icon to close the form. |
7 |
Table 17: Group by Column Offset Key Steps
Parameters
The following dialog / form appears, containing the parameters required to check the outline structure using your table data.
Figure 33 – Group by Column Offset Parameters Form
The table below describes the parameters in more detail.
Table 18: Group by Column Offset Parameters Description Table
Property Name |
Description |
Data Type |
---|---|---|
Function Parameters |
||
Outline Type |
Select the type of outline source data from the drop-down menu. Secondary inputs may be required after the outline type is selected. Please refer to the section on “Group By XXX” for information on the required parameters, where XXX is the type of grouping function indicated by the outline type, e.g. type “Outline Id” refers to section “Group by Outline Id”. |
String (Drop down) |
Source Range |
||
Source Range Address |
The source range for this function will be detected as the current active selection when the function is invoked. The address is shown to the right of the Refresh button. This source range can be changed after function invocation. |
n/a |
Refresh |
Click on the “Refresh” button to update the source selection. |
Recent Comments