UnGroup method

Ungroups data. Returns True if successful, otherwise False.

Applies to

TableData	ArrData	RsetData	Xdata	XShared
	✓

Parameters

Name	Type	Description
GroupFields	Value or array	The fields to be ungrouped.

The method ungroups where there is an array in one or more fields. The number of records created is equal to the number of values in the array, each value going into a record in the ungrouped data set. A two-dimensional array is ungrouped to one-dimensional arrays. Other fields are copied from the record being ungrouped.

All group fields must contain arrays with the same number of elements.

Escape characters in text arrays are restored to their original characters (see Group)

If a field has been converted to text by a Group operation, it remains text after the Ungroup but all such fields can be restored to their original types using RestoreTypes.

After a group/ungroup operation, the ArrData object will have the same number of records it had before and array fields will be as they were before.