Remove Grouping

Source Data

This function removes any previous grouping that has been applied to rows or columns by previous grouping functions.

Key Steps

To remove grouping from an existing table, follow the steps below.

Step #

Step Detail

1

Select the column or row that was previously grouped and which now you want ungrouped– those rows will be showing Excel grouping controls.

2

Click on the “Remove Grouping” button in the TreeWiz Ribbon Menu

3

Confirm that the source range is correct in the parameter form

4

Click on “OK’ to perform the function or “Cancel” to exit

5

The function will complete, and a dialog box will inform you on completion

6

Click on “Ok” button to dismiss the dialog box

7

 

Table 15: Group by Column Offset Key Steps

Parameters

The following dialog / form appears, containing the parameters required to create a metadata schema from your source data.

Figure 32 – Group by Column Offset Parameters Form

The table below describes the parameters in more detail.

Table 16: Group by Column Offset Parameters Description Table

Property Name

Description

Data Type

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.