JPH01232425A - Group sorting device - Google Patents

Abstract

(57) [Summary] This bulletin contains application data before electronic filing, so abstract data is not recorded.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a data processing device such as a personal computer, and particularly relates to a group sorting device suitable for tabulation work using spreadsheet data. .

[Prior Art J Data processing devices such as personal computers (personal computers) have traditionally been equipped with various data sorting functions. It is known that the
This can be found in the disclosures of Japanese Patent Application Laid-open No. 57-00757, or Japanese Patent Application Laid-Open No. 60-84634.

FIG. 6 shows an example of a data processing device. In FIG. 1, ■ is a central processing unit; 2 is an operating system; 3 is a keyboard; 4 is a CRT; In the processing, processing was performed as shown in FIG.

When the process 70 shown in FIG. m7 is started, the operator first operates the keyboard 3.

Sort data consisting of a key column to be sorted, a sorting criterion (ascending or descending order), and a sorting range (row range) is input (step 71).

Then, the validity of this sort data is checked (step 72), and if an error occurs here, as a process in step 73, that fact is displayed on the CRT 4, and the content of the error is notified. The sort data input operation is requested again.

If the result in step 72 is OK, that is, if there are no problems with the key column to be sorted, the sort criteria, or the range to be sorted, then first sort the rows in ascending or descending order according to the sort criteria. A sort is performed (step 74).

The results are then sequentially displayed on the CRT 4 starting from the first row of the sort range (step 75).

Therefore, in this case, the target of the sort is a single row, so even if the data includes multiple rows that are related to each other, it is not possible to sort the data in units of multiple rows. Can not.

[Problem to be solved by the invention]

The above-mentioned conventional technology only deals with sorting by row in spreadsheet data. There is a problem in that when attempting to sort a plurality of rows that are related based on characterizations other than 9, a rather complicated operation is required.

An object of the present invention is to provide a group sorting device that can easily perform the original sorting of grouping across a plurality of hierarchies without requiring particularly complicated operations.

[Means to solve the problem]

The above object is achieved by adding a predetermined group identification T to the data to be sorted, further calculating a group representative value using this group identifier, and performing sorting using this group representative value.

[For production]

It is now possible to create a group management table from the group identifier and group representative value of the data to be sorted, and by using the second created group management table, it is possible to perform arithmetic processing for sorting groups that differ by one level. Since it can be performed automatically, no particularly complicated operations are required.

〔Example〕

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A group sorting device according to the present invention will be explained in detail below using illustrated embodiments.

In this embodiment as well, the hardware configuration of the data processing device to which it is applied is the same as the conventional example shown in FIG. 6, but the software configuration for data processing is different. The processing shown in is now executed.

In this example, when performing the group sort,
It is necessary to input a group identifier, and therefore, the process 10 shown in FIG. 1 is executed first.

Therefore, when this process 10 is started,

In step 11, regarding the data to be sorted,
Determine the criteria for how to group the multiple rows of data.

Next, a column (group identification column) in which a group identifier is to be input in the data is determined (step 12).

Once the group criteria and group identification sequence have been determined in this way, then according to these.

Enter the group identifier (step 13).

While checking this by displaying it on the CRT4, step 1
Based on the judgment in step 5, group sorting of the data is repeated over the entire target range.

In this way, the state with the group identifier added is
It is shown in the figure (θ). In Fig. 4(a), the key column to be sorted is column B, the sort criterion is descending order, and the sort range is from rows 2 to 7.
This example shows an example in which G1 to G3 are added to column 0 as row and group identifiers.

After completing the process 10 for adding group identifiers in this manner, the sorting process shown in FIG. 2 is then executed.

Process 20 in Figure 2 begins at the end.

In steps 21.22.23, necessary data input processing operations are performed. Note that the processing operations at this time are the same as in steps 71 to 73 in the conventional example shown in FIG. In addition to the columns, sorting criteria, and the range to be sorted, in this embodiment, a group identification column that defines the group is also input.

If there are no problems with the key column to be sorted, sort key column, sort target range, and group identification column input in this way, first, use the same identifier of the group identification column to change the sort key column. Calculate representative values.

This is the representative value.

The sum or average value of the data in the columns within the group.

There are maximum values, minimum values, etc.

Once the representative values have been determined in this way, the group management table creation process shown in FIG. 3 is then performed in step 25.
In this example, the sales amount in column B in the data in FIG. 4 is used as the representative value.

The total value for each group is used.

Therefore, in this group management table, a group identifier and a group representative value corresponding to the group form a pair. For example, the representative value of a group whose group identifier is "05" is "500".

Once the group management table has been created, the process proceeds to step 26, where this table is used to perform sorting using the representative value of the group registered there as a key column, and then, in step 27, Process the target data based on the processing results, group the row data in units of the same identifier, rearrange it according to the sorting criteria,
The results are stored in a predetermined memory, and in step 28 the CRT 4
to be displayed.

FIG. 4(b) shows the sorting results according to the above embodiment.

In this example, the key column to be sorted is column B, the sort criteria is descending, the sort range is 2 to 7 rows, and the group identifier column is 6.
Since the representative value of the column and group is the total sales amount in column B, the sorting result is an array starting from the row data of group G3, followed by group G2, and then group G1. According to the embodiment, it is understood that group sorting can be easily obtained on a row-by-row basis for each predetermined group.

Next, FIG. 5 is a flowchart of operation processing in another embodiment of the present invention, which shows the processing of the conventional example explained in FIG. 7 and the processing of the embodiment of the present invention explained in FIG. With this combination, it is possible to perform sorting processing by selecting either data sorting on a single row basis or group sorting on multiple grouped rows.
A processing step 50 is provided, and depending on the judgment here, the process directly proceeds to step 74 to perform sorting on a line-by-line basis, or the process proceeds to steps 21 to 27.

It is decided whether to move to sorting based on the 41st place in the group.

Incidentally, in any case, the processing step 75 (28) is finally executed and the data is displayed in one row.

By the way, in one or more of the embodiments, sorting by group according to the present invention has been explained for spread sheet data. By doing so, it is also possible to apply the # of the group that corresponds to any actual work to the search.

In addition, the present invention sets the sorting target key to an arbitrary position of the record, sets the sorting range to Ref-1: range, F:, and makes the group identifier part of the key of the record.
Needless to say, it is possible to perform group sorting on large scale data, such as databases that are not limited to spreadsheet data.

〔Effect of the invention〕

According to the present invention, the unit is, for example, a data group of the number of rows of data. Sorting by group is extremely easy, so when processing data, it becomes easy to search for various characteristics that each piece of data shows in groups. effect can be obtained.

[Brief explanation of the drawing]

FIG. 1 is a flowchart illustrating the addition processing of group classification in an embodiment of the group sorting device according to the present invention, FIG. 2 is a flowchart illustrating the sorting process, and FIG. 3 is an explanatory diagram of the group management table. FIG. 4 is an explanatory diagram of group sorting in an embodiment of the present invention,
FIG. 5 is a flowchart illustrating the operation of another embodiment of the present invention, FIG. 6 is a block diagram illustrating an example of a data processing device to which the present invention is applied, and FIG. 7 is a flowchart illustrating the operation of a conventional example. It is. l... Central processing unit, 2... Oberete, Clink system, 3... Keyboard, 4... CRT
, 5... floppy de, C screen, 10.20...
・Processing step. Figures 10-15: Processing steps. Figure 2 Figure 4

Claims (1)

[Claims] 1. Input for adding a predetermined group identifier to each predetermined unit of data to be sorted in a data processing device that performs a data sorting function by inputting sort data including at least sort target keys, sort criteria, and sort range. and representative value calculation means for calculating a group representative value from the group of data in each predetermined unit based on the group identifier, and configured to sort the data into groups based on the group representative value. A group sorting device characterized by the following.