Data processing method, device, electronic device and storage medium
By determining the first tag information as the grouping basis in the data collaboration document, the data entries are split and grouped to display, the problem of multiple data items affecting data statistics is solved, and redundant display and accuracy are improved.
Patent Information
- Application Number
- CN202111161836.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-09-30
- Publication Date
- 2025-08-08
- Estimated Expiration
- 2041-09-30
AI Technical Summary
In a data collaboration document, after the grid table is converted into a Kanban view, multiple data items in the same data entry affect the correctness and presentation effect of data statistics.
By determining that the first tag information is the basis for grouping, the data entry set is split and grouped to display, ensuring that there is only one data item corresponding to the first tag information in each data entry, and setting homologous identification information for the split data entry.
It realizes the display of redundant data content, improves the accuracy and user experience of data statistics, and improves the visualization effect of data analysis.
Smart Images

Figure CN113986964B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of data processing technology, and in particular to a data processing method, device, electronic device and storage medium. Background Art
[0002] With the continuous development of information technology, people's requirements for data processing are becoming increasingly demanding, and data collaboration documents are widely used in data processing. Data collaboration documents can be used to edit and save data content. Data content in data collaboration documents can be displayed in grid tables, kanban views, or images. In other words, data collaboration documents are data tables that can display data content in multiple views (such as kanban views, grid tables, and picture albums).
[0003] Grid tables and Kanban views are both ways of displaying data collaboration documents. In some application scenarios, due to usage habits, user experience and other reasons, users hope to convert the data content in data collaboration documents from the grid table display format to the Kanban view display format. When users enter data content for data collaboration documents, they usually display the data content in the form of a grid table, such as various form filling tasks in daily life. However, it is common to enter multiple data items in one cell. Therefore, after converting such a grid table to a Kanban view, different data items will be displayed in the same Kanban view. For example Figure 1 As shown, after the data content in the grid table form is converted into the Kanban view form, Figure 1 The middle dashboard view contains attribute information 1, attribute information 2, and the data items corresponding to attribute information 2. Attribute information 2 is used as the grouping basis. In the fourth dashboard view, attribute information 2 contains two data items, "D" and "E," displayed in the same dashboard view.
[0004] Whether displaying data collaboration documents in a grid or a dashboard, there's a need for data statistics. However, if the same attribute information in a data entry corresponds to multiple data items, the accuracy of the statistics will be affected. Furthermore, displaying multiple data items in the same dashboard will also affect the presentation quality. Summary of the Invention
[0005] Based on the problems existing in the prior art, the present invention proposes a data processing method, device, electronic device and storage medium to disassemble the existing multi-label data content, while ensuring the integrity of the data content, avoiding the generation of redundant data content, facilitating users to perform data statistics and other processing on the data content, and improving the user experience.
[0006] In a first aspect, the present invention provides a data processing method, comprising:
[0007] determining the first tag information as a grouping basis, and grouping and displaying the data entries in the first data entry set according to the grouping basis;
[0008] The first tag information is determined according to the attribute information of the data entry; and there is only one data item corresponding to the first tag information of the data entry in the first data entry set.
[0009] Furthermore, according to the present invention, there is provided a data processing method, wherein determining the first tag information as a grouping basis, and grouping and displaying the data entries in the first data entry set according to the grouping basis, comprises:
[0010] Determining a second set of data entries based on the first input; wherein a data item of each data entry in the second set of data entries has corresponding attribute information;
[0011] Based on the second input, traverse each data entry in the second data entry set, split the first data entry therein into multiple second data entries, and obtain a first data entry set; based on the first tag information, group the data entries in the first data entry set for display;
[0012] The first tag information in the first data entry corresponds to more than one data item, and the first tag information in the second data entry corresponds to only one data item.
[0013] Furthermore, according to the present invention, there is provided a data processing method, wherein the displaying of data entries in the first data entry set in groups based on the first tag information comprises:
[0014] Generating corresponding kanban views for the data entries in the first data entry set respectively;
[0015] In the first data entry set, grouping data entries corresponding to the same data items of the first tag information into one group;
[0016] Set the kanban views corresponding to the same group of data entries to be displayed in the same kanban area.
[0017] Furthermore, according to the present invention, there is provided a data processing method, wherein splitting the first data entry into a plurality of second data entries comprises:
[0018] splitting the first data entry according to the data items corresponding to the first tag information in the first data entry;
[0019] Homologous identification information is set for the multiple second data entries obtained by splitting.
[0020] Furthermore, setting homology identification information for the plurality of second data entries obtained by splitting includes:
[0021] Setting the same identifier for each of the plurality of second data entries obtained by splitting;
[0022] Or, associated identifiers are set for the multiple second data entries obtained by splitting.
[0023] Furthermore, according to the present invention, there is provided a data processing method, which, after grouping and displaying the data entries in the first data entry set based on the first tag information, further comprises:
[0024] Based on a third input, deleting the first kanban view on the display interface and deleting a third data entry from the first data entry set; wherein the third data entry is the data entry corresponding to the first kanban view;
[0025] In the first data entry set, determining whether there is another data entry having the same source identification information as the third data entry;
[0026] In the case that the other data entries exist, the data item corresponding to the first tag information in the third data entry is deleted from the data entry before the third data entry is split.
[0027] Furthermore, according to the present invention, there is provided a data processing method, which, after determining whether there are other data entries having the same source identification information as the third data entry in the first data entry set, further comprises:
[0028] In the absence of the other data entries, if the third data entry is an unsplit data entry, directly delete the third data entry; if the third data entry is a split data entry, delete the data entry before the third data entry is split.
[0029] Furthermore, according to the present invention, there is provided a data processing method, which, after grouping and displaying the data entries in the first data entry set based on the first tag information, further comprises:
[0030] Adjusting the position of the second billboard view according to a movement instruction for the second billboard view on the display interface;
[0031] According to the adjusted new position of the second kanban view, the data item corresponding to the first tag information in the data entry corresponding to the second kanban view is updated.
[0032] Furthermore, according to the data processing method provided by the present invention, adjusting the position of the second kanban view according to the movement instruction for the second kanban view on the display interface, and updating the data item corresponding to the first tag information in the data entry corresponding to the second kanban view according to the new position of the adjusted second kanban view, includes:
[0033] Based on the fourth input, the second kanban view is moved on the display interface to the location of the third kanban view; wherein the data entry corresponding to the second kanban view is the fourth data entry, and the data entry corresponding to the third kanban view is the fifth data entry; and the fourth data entry and the fifth data entry are not in the same group;
[0034] determining whether the fourth data entry and the fifth data entry have the same source identification information;
[0035] In the absence of homology identification information, if the fourth data entry is a data entry obtained by splitting, in the data entry before the fourth data entry is split, the data item corresponding to the first tag information in the fourth data entry is changed to the data item corresponding to the first tag information in the fifth data entry; if the fourth data entry is a data entry that has not been split, in the fourth data entry, the data item corresponding to the first tag information is changed to the data item corresponding to the first tag information in the fifth data entry;
[0036] The kanban view corresponding to the modified fourth data entry and the third kanban view are set to be displayed in the same kanban area.
[0037] Furthermore, according to the present invention, there is provided a data processing method, which, after determining whether the fourth data entry and the fifth data entry have homologous identification information, further comprises:
[0038] In the case of homologous identification information, in the data entry before the fourth data entry is split, merging the data item corresponding to the first tag information in the fourth data entry and the data item corresponding to the first tag information in the fifth data entry;
[0039] Delete the second Kanban view.
[0040] Furthermore, according to the data processing method provided by the present invention, determining the first tag information as a grouping basis, and grouping and displaying the data entries in the first data entry set according to the grouping basis includes:
[0041] Determining a second set of data entries based on the first input; wherein a data item of each data entry in the second set of data entries has corresponding attribute information;
[0042] Based on the second input, determining the first tag information as a grouping basis, traversing the first tag information of each data entry in the second data entry set, splitting the first data entry into multiple second data entries to obtain a first data entry set; and grouping and displaying the data entries in the first data entry set according to the grouping basis;
[0043] The first tag information in the first data entry corresponds to more than one data item, and the first tag information in the second data entry corresponds to only one data item.
[0044] In a second aspect, the present invention further provides a data processing device, comprising:
[0045] a grouping display module, configured to determine the first tag information as a grouping basis, and group and display the data entries in the first data entry set according to the grouping basis;
[0046] The first tag information is determined according to the attribute information of the data entry; and there is only one data item corresponding to the first tag information of the data entry in the first data entry set.
[0047] In a third aspect, the present invention further provides an electronic device comprising: a processor, a memory, and a bus, wherein:
[0048] The processor and the memory communicate with each other via the bus;
[0049] The memory stores program instructions that can be executed by the processor, and the processor calls the program instructions to execute the steps of the data processing method described in any one of the above items.
[0050] In a fourth aspect, the present invention further provides a computer-readable storage medium, wherein the computer-readable storage medium stores computer instructions, and the computer instructions enable the computer to execute the steps of the data processing method as described above.
[0051] The data processing method provided by the present invention groups and displays the data entries in the first data entry set by determining the first tag information as the grouping basis, wherein each data entry in the first data entry set has only one data item corresponding to the first tag information, so that the display result is clear and there is no redundant data content. At the same time, the visualization effect of the group display is better, which is conducive to data analysis and statistics, improves the accuracy of data statistical results, and enhances user experience. BRIEF DESCRIPTION OF THE DRAWINGS
[0052] In order to more clearly illustrate the technical solutions in the present invention or the prior art, a brief introduction is given below to the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.
[0053] Figure 1 It is a schematic diagram of displaying data content in the form of a kanban view in the prior art;
[0054] Figure 2 It is a flow chart of a data processing method provided by the present invention;
[0055] Figure 3 This is an example diagram of a kanban view provided by the present invention;
[0056] Figure 4 This is an example diagram of a kanban view generated based on data entries using the data processing method provided by the present invention;
[0057] Figure 5 This is a schematic diagram of a view display with homologous identification information provided by the present invention;
[0058] Figure 6 This is one of the example images obtained by moving the kanban view provided by the present invention;
[0059] Figure 7 This is the second example diagram obtained by moving the kanban view provided by the present invention;
[0060] Figure 8 It is a structural schematic diagram of a data processing device provided by the present invention;
[0061] Figure 9 It is a structural schematic diagram of the electronic device provided by the present invention. DETAILED DESCRIPTION
[0062] To make the objectives, technical solutions, and advantages of the present invention more clear, the technical solutions of the present invention will be clearly and completely described below in conjunction with the accompanying drawings. Obviously, the embodiments described are only some of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts shall fall within the scope of protection of the present invention.
[0063] In one or more embodiments of this specification, horizontal and vertical directions; horizontal lines and vertical lines are used. The direction of the horizontal and horizontal lines refers to the horizontal direction parallel to the horizontal ground, based on the display interface that is recognizable to the naked eye when the user looks straight ahead, and the display interface displays the data content normally and accurately. The direction of the vertical and vertical lines refers to the vertical direction perpendicular to the horizontal ground, based on the display interface that is recognizable to the naked eye when the user looks straight ahead, and the display interface displays the data content normally and accurately.
[0064] The present invention can be applied to data collaboration documents. Data collaboration documents can be displayed in the form of a grid table, and can also be displayed in the form of a view. It is a data management document with multiple display forms. When the data content in the data collaboration document is displayed in the form of a grid table, the data content is arranged in each cell that constitutes a row, and / or arranged in each cell that constitutes a column. For the data content displayed on the display interface of the client, the display interface that can be recognized by the naked eye when the user looks straight ahead is used as the benchmark, and the display interface displays the data content normally and accurately. The row is the area composed of horizontal lines; the column is the area composed of vertical lines; and the table formed by the intersection of rows and columns is a cell.
[0065] Data content in data collaboration documents is organized and managed as data entries. A data entry is a collection of related data content in the same row or column. Each data entry can contain multiple data items, each of which has its own corresponding attribute information. A data item is the data content contained in a data entry, and attribute information describes the type of the data item.
[0066] When the data content (i.e., data) in a data collaboration document is displayed in the form of a grid table, the data entries correspond to the data content in the "rows" or the data content in the "columns" in the grid table; the data items correspond to the data content in the cells in the grid table; and the attribute information corresponds to the row headers or column headers of the cells.
[0067] The following describes the solution by taking the data content in the "row" in the grid table corresponding to the data entry as an example.
[0068] The data processing method provided by the present invention comprises the following steps:
[0069] determining the first tag information as a grouping basis, and grouping and displaying the data entries in the first data entry set according to the grouping basis;
[0070] The first tag information is determined according to the attribute information of the data entry; and there is only one data item corresponding to the first tag information of the data entry in the first data entry set.
[0071] In this embodiment, the first data entry set is a processed data set, specifically a set consisting of data entries corresponding to only one data item for the first tag information, where "only one data item" means that the cell corresponding to the first tag information has only one data value. It should be noted that in this embodiment, the first data entry set can be obtained by processing other types of data entry sets. In other embodiments, the first data entry set can also be obtained directly from the server, and this is not specifically limited here.
[0072] In this embodiment, first label information is determined based on the attribute information of the data entry, the first label information is determined as the grouping basis, and then the data entries in the first data entry set are grouped and displayed based on the obtained grouping basis, wherein the first label information is determined based on the attribute information of the data entry. In the case where the data content is displayed in the form of a grid table, the first label information refers to a field selected from the attribute information. The grouping basis is the condition based on which the data entries are grouped, such as in the data set of a personal resume table, the personal resume table is grouped according to academic qualifications. Group display is a method of displaying the grouped data entries according to groups, such as displaying data entries in the same group in the same row or column.
[0073] For example, the "Project Name, Participants, Completion Date" information in Table 1 below is all attribute information for a data item. You can select one of these attributes as the first tag, such as "Participants." If there are multiple similar data items, group them with the same participants and display them in the same row or column.
[0074] Table 1
[0075] Serial number Project Name Participants Completion Date Remark 1 Shanghai Project 1 Xiaohong 2021 / 7 / 14 Received praise from customers
[0076] In this embodiment, the first tag information is one of multiple attribute information of the data entry, and there is only one data item corresponding to the first tag information of the data entry in the first data entry set, while there may be multiple data items corresponding to other attribute information that is not determined as the first tag information, which is not specifically limited here.
[0077] The data processing method provided by the present invention groups and displays the data entries in the first data entry set by determining the first tag information as the grouping basis, wherein there is only one data item corresponding to the first tag information of each data entry in the first data entry set, so that the display result is clear and there is no redundant data content. At the same time, the visualization effect of the group display is better, which is conducive to data analysis and statistics, improves the accuracy of data statistical results, and enhances user experience.
[0078] Based on the above embodiment, in this embodiment, if Figure 2 As shown, determining the first tag information as a grouping basis, and grouping and displaying the data entries in the first data entry set according to the grouping basis includes the following steps:
[0079] Step 201: Determine a second set of data entries based on a first input;
[0080] Wherein, the data item of each data entry in the second data entry set has corresponding attribute information;
[0081] In this embodiment, when a user performs a first input through a computer or other human-computer interaction device, a desired second data entry set is obtained. The second data entry set is a set consisting of unprocessed original data content, including multiple data entries, some of which contain multiple data items, and each data item in each data entry has corresponding attribute information.
[0082] It should be noted that a data entry is a collection of data that is related to each other. Each data entry can contain multiple data items, each of which has its own attribute information. A data item is the individual data contained in the data entry, and the attribute information is used to describe the type of the data item.
[0083] Take the following Table 2 as an example of the second data entry set. In the following Table 2, each data item has corresponding attribute information. The data item corresponding to data entry 1 is "Shanghai Project One, Xiaohong, 2021 / 7 / 14, and received positive customer feedback". Among them, the attribute information corresponding to the data item "Shanghai Project One" is "Project Name"; the attribute information corresponding to the data item "Xiaohong" is "Participants"; the attribute information corresponding to the data item "2021 / 7 / 14" is "Completion Date"; the attribute information corresponding to the data item "Received positive customer feedback" is "Remarks". Data entry 2, data entry 3, and data entry 4 also have their own data items, and the data items and corresponding attribute information of these data entries will not be introduced one by one here.
[0084] Table 2
[0085]
[0086]
[0087] It should be noted that different data items in some data entries have the same attribute information. For example, the data item "Xiaohong" and the data item "Xiaolan" in data entry 3 both correspond to the attribute information "participant".
[0088] The first input is an input operation used to determine the second set of data items, such as an operation in which a user inputs individual data items in the second set of data items via a human-computer interaction device, or an operation in which a user selects a data item pre-stored on the human-computer interaction device via the human-computer interaction device to determine the second set of data items. In this embodiment, the specific form of the first input is not limited.
[0089] Step 202: Based on the second input, traverse each data entry in the second data entry set, split the first data entry therein into multiple second data entries, and obtain a first data entry set; based on the first tag information, group the data entries in the first data entry set and display them;
[0090] The first tag information in the first data entry corresponds to more than one data item, and the first tag information in the second data entry corresponds to only one data item.
[0091] The second data entry set has been determined in the previous step, and some data entries in the second data entry set contain data items but different data items correspond to the same attribute information. For example, in the previous example, the data item "Xiaohong" and the data item "Xiaolan" in data entry 3 both correspond to the attribute information "participant".
[0092] In this embodiment, first tag information is assigned to each data entry in the second data entry set. The first tag information is determined based on attribute information and serves as the basis for grouping the data entries. For example, in the example in Table 2 above, the data entries in the second data entry set include the attribute information "Project Name," "Participants," "Completion Date," and "Remarks." From this attribute information, "Participants" is selected as the first tag information. In subsequent steps, the data entries in Table 2 will be grouped and displayed using "Participants" as the grouping basis.
[0093] In the determined second data entry set, data entries that have more than one data item corresponding to the first tag information are recorded as first data entries, i.e., first data entries are data entries in which multiple data values exist in the cell corresponding to the determined first tag information. In this embodiment, in response to the second input, the first data entry is split, such that the data entries obtained after the splitting have only one data item corresponding to the first tag information. The data entries obtained after such splitting are recorded as second data entries, i.e., second data entries are data entries in which only a single data value exists in the cell corresponding to the determined first tag information.
[0094] The second input is an instruction for instructing to split the first data entry in the second data entry set. The second input can be a user clicking a preset button on the interactive interface of the human-computer interaction device, or a code instruction entered by the user. The specific form of the second input is not limited in this embodiment.
[0095] After splitting the first data entry in the second data entry set into second data entries, all data entries in the obtained first data entry set are second data entries, that is, there is only one data item corresponding to the first tag information of all data entries.
[0096] For example, in the example in Table 2 above, data item "Xiaohong" and data item "Xiaolan" in data entry 3 both correspond to the attribute information "Participant." This data entry is the first data entry. Therefore, it needs to be split. When splitting, only the multiple data items with the same attribute information in the first data entry need to be split into different data entries, and the remaining attribute information is copied to each of the split data entries.
[0097] For example, data entry 3 "Guangzhou Project Three, Xiaohong, Xiaolan, 2021 / 7 / 29, timely response" is split into two data entries, namely: "Guangzhou Project Three, Xiaohong, 2021 / 7 / 29, timely response" and "Guangzhou Project Three, Xiaolan, 2021 / 7 / 29, timely response".
[0098] After splitting the second data entry set in the example of Table 2, the resulting first data entry set is shown in Table 3. It should be noted that in this embodiment, the terms "first data entry" and "second data entry" are primarily used to describe the type of data entry and do not impose a limit on the number of data entries. That is, in the second data entry set, there can be one or more first or second data entries.
[0099] Table 3
[0100] Serial number Project Name Participants Completion Date Remark 1 Shanghai Project 1 Xiaohong 2021 / 7 / 14 Received praise from customers 2 Changsha City Project 2 Xiaolan 2021 / 6 / 24 3 Guangzhou Project 3 Xiaohong 2021 / 7 / 29 Timely response 4 Dongguan City Project 4 Xiaofang 2021 / 7 / 14 5 Guangzhou Project 3 Xiaolan 2021 / 7 / 29 Timely response
[0101] After obtaining the first data entry set, the data entries in the first data entry set are grouped. When grouping, the aforementioned first label information is used as the basis for grouping. For example, the first data entry set shown in Table 3 uses the attribute information "participants" as the first label information. When grouping the data entries in the first data entry set, referring to the data items corresponding to the first label information, data entry 1 and data entry 3 in Table 3 can be grouped into one group (all participants are Xiaohong), data entry 2 and data entry 5 in Table 3 can be grouped into one group (all participants are Xiaolan), and data entry 4 in Table 3 can be grouped into one group (all participants are Xiaofang).
[0102] After completing the grouping of all data entries in the first data entry set, the data entries are grouped and displayed. For example, data entries in the same group are displayed in the same row, or in the same column. The specific implementation method of the grouped display is not limited in this embodiment.
[0103] The data processing method provided by the present invention splits more than one data entry corresponding to the first tag information, and then uses the first tag information as the grouping basis to group and display the data entries in the data entry set, so that the display results are clear, there is no redundant data content, the data content display effect is intuitive, the accuracy of the data statistical results is improved, and the user experience is enhanced.
[0104] Based on any of the above embodiments, in this embodiment, grouping and displaying data entries in the first data entry set based on the first tag information includes:
[0105] Generate corresponding kanban views for each of the data entries in the first data entry set;
[0106] In the first data entry set, grouping data entries corresponding to the same data items of the first tag information into one group;
[0107] Set the kanban views corresponding to the same group of data entries to be displayed in the same kanban area.
[0108] In this embodiment, data entries are displayed in a kanban view, which is a view used to clearly display data status in a kanban manner. Figure 3 This is a schematic diagram of the kanban view provided in this embodiment. As can be seen from the figure, the kanban view contains two areas: Area A and Area B. Area A is used to display the attribute information used as the grouping basis for a data entry, and Area B is used to display other attribute information for the data entry. The attribute information in Area A serves as the grouping basis, while Area B displays the relevant information for a data entry. Each kanban view contains all the data items for a data entry and describes the attribute information corresponding to the data items.
[0109] In this embodiment, when grouping and displaying data items in the first data item set, a corresponding kanban view may be generated for each data item. Then, based on the grouping results, the kanban views corresponding to the data items in the same group are set to the same kanban area for display. A kanban area refers to an area used to display kanban views. The same kanban area means displaying the same group of data items within the same sub-area of a kanban view.
[0110] It should be noted that in this embodiment, when kanban views corresponding to data entries in the same group are displayed in the same kanban area, they are displayed using a preset same-group display rule. This same-group display rule can be to display kanban views corresponding to data entries in the same group in the same column or in the same row. The specific setting can be based on actual needs and is not limited in this embodiment.
[0111] Figure 4 The diagram is a diagram showing the data items in the first data item set shown in Table 3 being grouped and displayed in a kanban view. When "participants" is used as the grouping basis, the data item corresponding to the first label information of data item 1 is "Xiaohong", the data item corresponding to the first label information of data item 2 is "Xiaolan", the data item corresponding to the first label information of data item 3 is "Xiaohong", the data item corresponding to the first label information of data item 4 is "Xiaofang", and the data item corresponding to the first label information of data item 5 is "Xiaolan". It can be seen that the data items of the first label information of data item 1 and data item 3 are the same, and the data items of the first label information of data item 2 and data item 5 are the same. When generating the corresponding kanban view, the data items with the same data items corresponding to the first label information are automatically grouped in the same group and arranged in the vertical arrangement order, resulting in Figure 4 The Kanban view shown, Figure 4 The number in the upper right corner indicates the number of data items of the first tag information in each group. For example, if the number in the upper right corner of the first group of kanban views is 2, it means that there are 2 data items.
[0112] from Figure 4 The Kanban view shows that Xiaolan completed "Changsha Project 2" and "Guangzhou Project 3," Xiaohong completed "Shanghai Project 1" and "Guangzhou Project 3," and Xiaofang completed "Dongguan Project 4." Furthermore, the Kanban view provides access to information contained in data entries, such as completion dates and notes.
[0113] It should be noted that multiple data items refer to the presence of multiple values in a cell. For example, in Table 2 above, a cell contains two participants, "Xiaohong and Xiaolan", which are two data items. When there is only one value in the cell corresponding to the first tag attribute of each data item, the number of data items is one. In this embodiment, the number of data items can be determined based on the number of semicolons or commas in the numerical content of a cell. In other embodiments, other judgment methods can also be used, such as judging and confirming based on the number of nickname attribute values. When the data value corresponding to the nickname attribute in the cell is 2, it means that there are two data items in the cell. The method for determining the number of data items can be set according to actual needs and is not specifically limited here.
[0114] The data processing method provided by the present invention, when traversing to the existence of multiple data items corresponding to the same attribute information in the same data entry, splits the multiple data items of the data entry to form multiple data entries with a single data item, generates corresponding kanban views for the data entries, and automatically groups the kanban views corresponding to the data entries with the same data items into a group, and sets the kanban views of the same group to be displayed in the same kanban area. Each kanban view is displayed clearly and regularly, and is simple and convenient to operate, thereby improving the user experience.
[0115] Based on any of the above embodiments, in this embodiment, the first data entry is split into multiple second data entries, including:
[0116] Splitting the first data entry according to the data item corresponding to the first tag information in the first data entry;
[0117] Homologous identification information is set for the multiple second data entries obtained by splitting.
[0118] Specifically, homology means that two or more data entries have the same data source, and homology identification means that two or more split data entries have the same identification information. In this embodiment, the homology identification can be the same ID value, the same code mark, or other representations. The homology identification set for each data entry is unique, and the homology identification corresponding to each data entry is different. After setting the homology identification for each data entry, the corresponding data entry can be obtained based on the set homology identification information; similarly, the corresponding homology identification information can be obtained for the data entry as needed.
[0119] In this embodiment, homologous identification information refers to information with the same tag. Tag information can exist in various forms. In this embodiment, the same ID value is used as the homologous identification information. The first data entry refers to a data entry in which the number of data items corresponding to the first tag information is greater than 1, and an ID value is set for it. After receiving the second input, the human-computer interaction device traverses each data entry in the second data entry set and splits the first data entry therein to obtain multiple second data entries. Since these second data entries are all split from the same first data entry, these second data entries have the same ID value as the first data entry.
[0120] For example, in the example shown in Table 2, the first data entry is the corresponding data entry 3 in Table 2, "Guangzhou Project Three, Xiaohong, Xiaolan, 2021 / 7 / 29, timely response". When "Participants" is selected as the grouping basis, "Xiaohong, Xiaolan" in data entry 3 is split into "Xiaolan" and "Xiaohong", that is, data entry 3 is split into two data entries, and the same ID value is set for these two data entries as homologous identification information. One of the two data entries obtained after the split is "Guangzhou Project Three, Xiaohong, 2021 / 7 / 29, timely response, ID value 1234", and the other data entry is "Guangzhou Project Three, Xiaolan, 2021 / 7 / 29, timely response, ID value 1234". The results obtained after processing the second data entry set shown in Table 2 are shown in Table 4 below (ID values only show data entry 3 and data entry 5). Data entry 3 and data entry 5 are obtained by splitting the same data entry.
[0121] Table 4
[0122]
[0123] It should be noted that in this embodiment, the first data entry is split into multiple second data entries equal to the number of data items corresponding to the first tag information of the first data entry. In other words, the number of data items determines the number of second data entries. For example, if the number of data items corresponding to the first tag information in a data entry is 4, the data entry can be split into 4 new data entries, and the number of data items corresponding to the first tag information in each of the new data entries is 1.
[0124] Figure 5The kanban views generated based on the data entries in Table 4 above have a number in the upper right corner indicating the number of data entries within the group. For example, the group based on participant "Xiao Lan" has two data entries, describing Xiao Lan's participation in Changsha Project 2 and Guangzhou Project 3, respectively. Therefore, the corresponding number 2 is displayed in the upper right corner. The two kanban views in the last row are marked with the numerical symbols ① and ② in the lower right corner, indicating that the two kanban views have the same source identification information. In other words, the data entries corresponding to the two kanban views are derived from the same data entry.
[0125] According to the data processing method provided by an embodiment of the present invention, a first data entry with multiple tags is split to obtain multiple second data entries, and homologous identification information is set for the multiple second data entries, so as to facilitate the corresponding changes in the attribute information of the original data entries when the respective kanban views are subsequently deleted or moved.
[0126] Based on any of the foregoing embodiments, setting homology identification information for the multiple second data entries obtained by splitting includes:
[0127] Setting the same identifier for each of the plurality of second data entries obtained by splitting;
[0128] Alternatively, associated identifiers are set for each of the multiple second data entries obtained by splitting.
[0129] In this embodiment, the homologous identification information includes the same identifier and associated identifiers, wherein the multiple second data entries obtained after the same identifier is split as described in the above embodiment have the same ID value as the first data entry before the split, which will not be described in detail here.
[0130] In an embodiment, associated identifiers are set for the multiple second data entries obtained by splitting, and association means that they belong to the same topic and there is a certain connection between the data entries. For example, in the example shown in Table 2 above, the first data entry is the corresponding data entry 3 in Table 2, "Guangzhou Project Three, Xiaohong, Xiaolan, 2021 / 7 / 29, timely response". When "Participants" is selected as the grouping basis, "Xiaohong, Xiaolan" in data entry 3 is split into "Xiaolan" and "Xiaohong", which means that data entry 3 is split into two data entries, and the identifier "1" is set for data entry 3. The two second data entries obtained by splitting are set to associated identifiers "1-1" and "1-2", that is, one of the two data entries obtained after splitting is "Guangzhou Project Three, Xiaohong, 2021 / 7 / 29, timely response, 1-1", and the other data entry is "Guangzhou Project Three, Xiaolan, 2021 / 7 / 29, timely response, 1-2". It should be noted that the associated identifier is identification information that indicates a certain connection between multiple data entries. The specific form of the identification information can be set according to actual needs and is not limited to the form of "1", "1-1" and "1-2". No specific limitation is made here.
[0131] According to the data processing method provided by an embodiment of the present invention, when setting homologous identification information for multiple second data entries, it can be the same identification or related identification. The setting method has no limitations, which facilitates the subsequent deletion or movement operations of each kanban view to achieve corresponding changes in the original data entry attribute information.
[0132] Based on any of the above embodiments, in this embodiment, after grouping and displaying the data entries in the first data entry set based on the first tag information, the method further includes:
[0133] Based on the third input, deleting the first kanban view on the display interface and deleting a third data entry from the first data entry set; wherein the third data entry is the data entry corresponding to the first view;
[0134] In the first data entry set, determining whether there is another data entry having the same source identification information as the third data entry;
[0135] In the case that other data entries exist, in the data entry before the third data entry is split, the data item corresponding to the first tag information in the third data entry is deleted.
[0136] Specifically, the third input refers to the user's operation of deleting the board view.
[0137] In an embodiment of the present invention, when the user enters the third input, the background will delete the selected first kanban view on the display interface according to the input deletion information, and delete the third data entry from the first data entry set.
[0138] Then, determine whether there are other data entries with the same source identification information for the data entry to be deleted. If so, perform corresponding processing operations on the data entry before the split corresponding to the first kanban view to be deleted, that is: the third data entry corresponding to the first kanban view is the data entry obtained after the split, and the data item corresponding to the first label information of the third data entry in the corresponding data entry before the split needs to be directly deleted, and the data items corresponding to the first label information of the remaining other data entries obtained by the split remain.
[0139] For example, when the first kanban view is the kanban view corresponding to data entry 5 in Table 3, the data entry 5 corresponding to the kanban view is "Guangzhou City Project Three, Xiaolan, 2021 / 7 / 29, timely response." However, this data entry is a data entry obtained after the split. The corresponding data entry before the split was "Guangzhou City Project Three, Xiaohong, Xiaolan, 2021 / 7 / 29, timely response." That is, the data item in the first tag information of the data entry before the split was "Xiaohong, Xiaolan." When the first kanban view corresponding to "Xiaolan" is deleted, the data item in the first tag information of the data entry before the split "Xiaohong, Xiaolan" is correspondingly updated to "Xiaohong." The changes in the data entry tag information are shown in Table 5 below.
[0140] Table 5
[0141]
[0142] According to the data processing method provided by the embodiment of the present invention, the user operates on the board view and simultaneously updates the label information of the data items corresponding to the board view in real time, thereby ensuring the accuracy and timeliness of data processing.
[0143] Based on any of the above embodiments, in this embodiment, after determining whether there are other data entries having the same source identification information as the third data entry in the first data entry set, the method further includes:
[0144] In the absence of other data entries, if the third data entry is an unsplit data entry, the third data entry is directly deleted; if the third data entry is a split data entry, the data entry before the third data entry is split is deleted.
[0145] In this embodiment, when it is determined that there are no other data entries with the same source identification information for the data entry corresponding to the first kanban view to be deleted, if it can be determined that the third data entry to be deleted is not the data entry obtained by splitting, the third data entry is directly deleted; if it is determined that the third data entry is the data entry obtained by splitting, it means that the other data entries obtained by splitting and having the same source identification information as the third data entry have been deleted, and the third data entry is the last data entry in the splitting result. The third data entry is deleted from the first data entry set, and the data entry before the third data entry is split is deleted at the same time.
[0146] For example, when the third data entry is the data entry corresponding to the first label information described in Table 6 below, and the value of the data item is "Xiao Lan", and the third data entry is the data entry that has not been split, it can be seen that there is only one data item corresponding to the first label information of the third data entry, and it has a single homologous identification information. When the user wants to delete the kanban view corresponding to the third data entry, the background can directly delete the third data entry.
[0147] Table 6
[0148]
[0149] When the third data entry is the data entry obtained by splitting, since there are no other data entries, when the kanban view corresponding to the third data entry is to be deleted, the third data entry is deleted in the first data set. At the same time, the data item corresponding to the first label information in the data entry before splitting needs to be deleted. At this time, the data item corresponding to the first label information in the data entry before splitting is empty, so the data entry before splitting can be deleted as a whole.
[0150] Optionally, when the user wants to delete multiple kanban views at the same time, and the corresponding data entries in the multiple kanban views are either split or not, the corresponding data entries can be processed accordingly according to the above embodiment.
[0151] According to the data processing method provided by an embodiment of the present invention, the data entries corresponding to the kanban view to be deleted are processed accordingly according to the user's deletion action on the kanban view, thereby ensuring the correspondence between the data entries and the kanban view and the accuracy of data processing.
[0152] Based on any of the above embodiments, in this embodiment, after grouping and displaying the data entries in the first data entry set based on the first tag information, the method further includes:
[0153] Adjusting the position of the second billboard view according to a movement instruction for the second billboard view on the display interface;
[0154] According to the adjusted new position of the second kanban view, the data item corresponding to the first tag information in the data entry corresponding to the second kanban view is updated.
[0155] In this embodiment, when a user moves a kanban view on a display interface, the data item corresponding to the first tag information in the data entry corresponding to the kanban view needs to be updated. It should be noted that when updating the data item corresponding to the first tag information in the data entry corresponding to the kanban view to be moved, it is necessary to determine the type of data entry in the first data entry set corresponding to the kanban view to be moved. For details, see the following embodiment.
[0156] According to the data processing method provided by an embodiment of the present invention, the second kanban view is moved according to the moving instruction of the kanban view, and the data items corresponding to the label information of the data entries corresponding to the moved second kanban view are updated according to the adjusted new position, thereby ensuring the correspondence between the data entries and the kanban views and the accuracy of data processing.
[0157] Based on any of the foregoing embodiments, in this embodiment, adjusting the position of the second billboard view according to a movement instruction for the second billboard view on the display interface, and updating the data item corresponding to the first tag information in the data entry corresponding to the second billboard view according to the new position of the adjusted second billboard view include:
[0158] Based on the fourth input, the second kanban view is moved on the display interface to the location of the third kanban view; wherein the data entry corresponding to the second kanban view is the fourth data entry, and the data entry corresponding to the third kanban view is the fifth data entry; and the fourth data entry and the fifth data entry are not in the same group;
[0159] determining whether the fourth data entry and the fifth data entry have the same source identification information;
[0160] In the absence of homology identification information, if the fourth data entry is a data entry obtained by splitting, in the data entry before the fourth data entry is split, the data item corresponding to the first tag information in the fourth data entry is changed to the data item corresponding to the first tag information in the fifth data entry; if the fourth data entry is a data entry that has not been split, in the fourth data entry, the data item corresponding to the first tag information is changed to the data item corresponding to the first tag information in the fifth data entry;
[0161] The kanban view corresponding to the changed fourth data entry and the third kanban view are set to be displayed in the same kanban area.
[0162] Specifically, the fourth input refers to an operation of the user moving the board view.
[0163] In this embodiment, when the human-computer interaction device receives the fourth input and moves the second skeptical view to the location of the third skeptical view, the label information in the corresponding data entry needs to be updated accordingly.
[0164] When the fourth data entry corresponding to the second Kanban view and the fifth data entry corresponding to the third Kanban view do not have the same source identifier, and it is determined that the fourth data entry is a split data entry, it is necessary to change the data item corresponding to the first tag information in the fourth data entry to the data item corresponding to the first tag information in the fifth data entry, such as Figure 5 In the kanban view shown, when the kanban view below the "Xiaohong" group is moved to the "Xiaofang" group, the data item "Xiaohong" corresponding to the first label information in the data entry before the split will be updated to "Xiaofang", and finally the data item "Xiaolan, Xiaohong" corresponding to the first label information in the data entry before the split will be updated to "Xiaolan, Xiaofang", and a new kanban view will be generated as shown in the figure. Figure 6 The specific data item updates corresponding to the first tag information are shown in Table 7 below.
[0165] Table 7
[0166]
[0167] When it is determined that the fourth data entry is a data entry that has not been split, the data item corresponding to the first label information in the fourth data entry needs to be changed to the data item corresponding to the first label information in the fifth data entry; as shown in Table 7, when the view corresponding to "Xiao Lan" is moved to the "Xiao Fang" group, the data item "Xiao Lan" corresponding to the first label information in the fourth data entry will be updated to "Xiao Fang", and the data item corresponding to the first label information after the final update is "Xiao Fang".
[0168] It should be noted that if the kanban view is moved within the same group, such as adjusting the position of the kanban view corresponding to the Guangzhou project three completed by Xiaolan and the kanban view corresponding to the Changsha project two completed by Xiaolan, the content of the data items corresponding to the kanban view will not change, so this situation will not be discussed in this embodiment.
[0169] According to the data processing method provided in an embodiment of the present invention, by updating the data items corresponding to the label information of the data entries corresponding to the kanban view to be moved according to the user's movement action on the kanban view, the correspondence between the data entries and the kanban view is ensured, and the accuracy of data processing is improved.
[0170] Based on any of the above embodiments, in this embodiment, after determining whether the fourth data entry and the fifth data entry have the same source identification information, the method further includes:
[0171] In the case of homologous identification information, in the data entry before the fourth data entry is split, merging the data item corresponding to the first tag information in the fourth data entry and the data item corresponding to the first tag information in the fifth data entry;
[0172] Delete the second Kanban view.
[0173] Specifically, having the same-source identification information means that the fourth data entry corresponding to the second kanban view and the fifth data entry corresponding to the third kanban view are obtained by splitting the same data entry.
[0174] In this embodiment, when the fourth data entry and the fifth data entry have the same source identification information, the fourth data entry is determined to be a split data entry, and it is necessary to change the data item corresponding to the first tag information of the fourth data entry to the data item corresponding to the first tag information of the fifth data entry in the data entry before the fourth data entry is split, and delete the duplicate kanban view at the same time. Figure 5 When the lower kanban view in the "Xiaohong" group is moved to the "Xiaolan" group, the data entries corresponding to the two kanban views have the same source identification information. In the data entry before being split, the data item "Xiaohong" corresponding to the first label information in the fourth data entry is updated to "Xiaolan", forming "Xiaolan, Xiaolan". In order to avoid duplication, the data item corresponding to the repeated first label information is removed, and finally the data item corresponding to the original first label information "Xiaolan, Xiaohong" is updated to "Xiaolan", and a new kanban view is generated as follows Figure 7 The details are shown in Table 8 below.
[0175] Table 8
[0176]
[0177] According to the data processing method provided by an embodiment of the present invention, the data items corresponding to the label information of the data entries corresponding to the view are updated in real time through the user's movement operation on the board view, thereby ensuring the accuracy and timeliness of data processing.
[0178] Based on any of the above embodiments, in this embodiment, determining the first tag information as a grouping basis, and grouping and displaying the data entries in the first data entry set according to the grouping basis includes:
[0179] Determining a second set of data entries based on the first input; wherein a data item of each data entry in the second set of data entries has corresponding attribute information;
[0180] Based on the second input, determining the first tag information as a grouping basis, traversing the first tag information of each data entry in the second data entry set, splitting the first data entry into multiple second data entries to obtain a first data entry set; and grouping and displaying the data entries in the first data entry set according to the grouping basis;
[0181] The first tag information in the first data entry corresponds to more than one data item, and the first tag information in the second data entry corresponds to only one data item.
[0182] In this embodiment, the first input refers to an input operation that determines a second set of data items. When a user performs the first input through a human-computer interaction device such as an electronic computer, the second set of data items is obtained. First tag information is then determined from the attribute information corresponding to the data items of each data item in the second set of data items. Based on the second input, the determined first tag information is used as a grouping basis. By traversing the first tag information of each data item in the second set of data items, the first data items are split into multiple second data items, thereby obtaining the first set of data items.
[0183] It should be noted that in this embodiment, after obtaining the second data entry set, a grouping basis is first determined. Then, based on the grouping basis, each data entry in the second data entry set is traversed, only the data items in the column or row corresponding to the grouping basis are traversed, and the first data entry corresponding to the multiple data items under the grouping basis is split and processed to obtain multiple second data entries, forming the first data entry set. Compared with the previous embodiment, this embodiment does not require traversing and splitting the data entries under each attribute information. Instead, it only requires splitting the columns or rows corresponding to the determined grouping basis. Finally, based on the grouping basis, the data entries in the first data entry set are grouped and displayed.
[0184] According to the data processing method provided by the present invention, by first determining the first tag information as the grouping basis, and then splitting the data entries with more than one data item in the column or row corresponding to the grouping basis to obtain a first data entry set, and then grouping and displaying the data entries in the obtained first data entry set according to the grouping basis, the speed of data entry splitting processing is improved, the accuracy of data statistical results is improved, and the user experience is enhanced.
[0185] The data processing device provided by the present invention includes:
[0186] a grouping display module, configured to determine the first tag information as a grouping basis, and group and display the data entries in the first data entry set according to the grouping basis;
[0187] The first tag information is determined according to the attribute information of the data entry; and there is only one data item corresponding to the first tag information of the data entry in the first data entry set.
[0188] The data processing device provided according to the embodiment of the present invention can ensure that the group display is clear and no redundant data content is generated. At the same time, the visualization effect of the group display is better, which is conducive to data analysis and statistics, improves the accuracy of data statistical results, and enhances user experience.
[0189] Based on any of the above embodiments, Figure 8 As shown, the device further includes a determination module 801 and a traversal and splitting module 802:
[0190] The determination module 801 is configured to determine a second data entry set based on the first input; wherein the data item of each data entry in the second data entry set has corresponding attribute information;
[0191] The traversal and splitting module 802 is configured to traverse each data entry in the second data entry set based on the second input, split the first data entry therein into multiple second data entries, and obtain a first data entry set; and group and display the data entries in the first data entry set based on the first tag information;
[0192] The first tag information in the first data entry corresponds to more than one data item, and the first tag information in the second data entry corresponds to only one data item.
[0193] The data processing device provided by the embodiment of the present invention can ensure that the view does not generate redundant data content, the group display is clear, and the user experience is improved.
[0194] Based on any of the above embodiments, in this embodiment, the traversal and splitting module 802 is further configured to:
[0195] Generate corresponding kanban views for each of the data entries in the first data entry set;
[0196] In the first data entry set, grouping data entries corresponding to data items of the first tag information that have the same value;
[0197] Set the kanban views corresponding to the same group of data entries to be displayed in the same kanban area.
[0198] According to the data processing device provided by an embodiment of the present invention, when the device traverses and finds that there are multiple data items corresponding to the same attribute information in the same data entry, the multiple data items of the data entry are split to form multiple data entries with a single data item, and corresponding kanban views are generated for the data entries. The kanban views corresponding to the data entries with the same data items are automatically divided into a group, and the kanban views of the same group are set to be displayed in the same kanban area. Each kanban view is displayed clearly and regularly, and the operation is simple and convenient, which improves the user experience.
[0199] Based on any of the above embodiments, in this embodiment, the traversal and splitting module 802 is further configured to:
[0200] Splitting the first data entry according to the data item corresponding to the first tag information in the first data entry;
[0201] Homologous identification information is set for the multiple second data entries obtained by splitting.
[0202] According to the data processing device provided by an embodiment of the present invention, a first data entry with multiple tags is split to obtain multiple second data entries, and homologous identification information is set for the multiple second data entries, so as to facilitate the corresponding changes in the attribute information of the original data entries when the respective kanban views are subsequently deleted or moved.
[0203] Based on any of the above embodiments, in this embodiment, the traversal and splitting module 802 is further configured to:
[0204] Setting the same identifier for each of the plurality of second data entries obtained by splitting;
[0205] Or, associated identifiers are set for the multiple second data entries obtained by splitting.
[0206] According to the data processing device provided by the embodiment of the present invention, by setting different forms of homologous identification information for multiple second data entries, it is convenient to implement corresponding changes in the original data entry attribute information when each kanban view is subsequently deleted or moved.
[0207] Based on any of the above embodiments, in this embodiment, the data processing device further includes a deletion module, and the deletion module is configured to:
[0208] Based on the third input, deleting the first kanban view on the display interface and deleting a third data entry from the first data entry set; wherein the third data entry is the data entry corresponding to the first kanban view;
[0209] In the first data entry set, determining whether there is another data entry having the same source identification information as the third data entry;
[0210] In the case that other data entries exist, in the data entry before the third data entry is split, the data item corresponding to the first tag information in the third data entry is deleted.
[0211] According to the data processing device provided by the embodiment of the present invention, the user operates on the board view and updates the label information of the data items corresponding to the view in real time, thereby ensuring the accuracy and timeliness of data processing.
[0212] Based on any of the above embodiments, in this embodiment, the deletion module is further configured to:
[0213] In the absence of the other data entries, if the third data entry is an unsplit data entry, the third data entry is directly deleted; if the third data entry is a split data entry, the data entry before the third data entry is split is deleted.
[0214] The data processing device provided in an embodiment of the present invention ensures the correspondence between data and views and the accuracy of data processing by performing corresponding processing on the data entries corresponding to the view to be deleted according to the user's deletion action on the board view.
[0215] Based on any of the above embodiments, in this embodiment, the data processing device further includes a moving module, and the moving module is configured to:
[0216] Adjusting the position of the second billboard view according to a movement instruction for the second billboard view on the display interface;
[0217] According to the adjusted new position of the second kanban view, the data item corresponding to the first tag information in the data entry corresponding to the second kanban view is updated.
[0218] According to the data processing device provided by an embodiment of the present invention, by updating the data items corresponding to the label information of the data entries corresponding to the kanban view to be moved according to the user's movement action on the kanban view, the correspondence between the data entries and the kanban view is guaranteed, and the accuracy of data processing is guaranteed.
[0219] Based on any of the above embodiments, in this embodiment, the mobile module is further configured to:
[0220] Based on the fourth input, the second kanban view is moved on the display interface to the location of the third kanban view; wherein the data entry corresponding to the second kanban view is the fourth data entry, and the data entry corresponding to the third kanban view is the fifth data entry; and the fourth data entry and the fifth data entry are not in the same group;
[0221] determining whether the fourth data entry and the fifth data entry have the same source identification information;
[0222] In the absence of homology identification information, if the fourth data entry is a data entry obtained by splitting, in the data entry before the fourth data entry is split, the data item corresponding to the first tag information in the fourth data entry is changed to the data item corresponding to the first tag information in the fifth data entry; if the fourth data entry is a data entry that has not been split, in the fourth data entry, the data item corresponding to the first tag information is changed to the data item corresponding to the first tag information in the fifth data entry;
[0223] The kanban view corresponding to the changed fourth data entry and the third kanban view are set to be displayed in the same kanban area.
[0224] According to the data processing device provided by an embodiment of the present invention, the data entry corresponding to the kanban view to be moved is updated with the data item corresponding to the label information according to the user's movement action on the kanban view, thereby ensuring the correspondence between the data entry and the kanban view and the accuracy of data processing.
[0225] Based on any of the above embodiments, in this embodiment, the mobile module is further configured to:
[0226] In the case of homologous identification information, in the data entry before the fourth data entry is split, merging the data item corresponding to the first tag information in the fourth data entry and the data item corresponding to the first tag information in the fifth data entry;
[0227] Delete the second Kanban view.
[0228] According to the data processing device provided by the embodiment of the present invention, the data items corresponding to the label information of the data entries corresponding to the kanban view are updated in real time through the user's movement operation on the kanban view, thereby ensuring the accuracy and timeliness of data processing.
[0229] Based on any of the above embodiments, in this embodiment, the group display module is further configured to:
[0230] Determining a second set of data entries based on the first input; wherein a data item of each data entry in the second set of data entries has corresponding attribute information;
[0231] Based on the second input, determining the first tag information as a grouping basis, traversing the first tag information of each data entry in the second data entry set, splitting the first data entry into multiple second data entries to obtain a first data entry set; and grouping and displaying the data entries in the first data entry set according to the grouping basis;
[0232] The first tag information in the first data entry corresponds to more than one data item, and the first tag information in the second data entry corresponds to only one data item.
[0233] The data processing device provided according to an embodiment of the present invention can ensure that the view does not generate redundant data content, so that the visualization effect of the generated board view is better, the group display is clear, which is conducive to data analysis and statistics, and at the same time improves the speed of data entry splitting processing and enhances the user experience.
[0234] Since the principles of the apparatus described in the embodiment of the present invention are the same as those of the method described in the above embodiment, more detailed explanations are omitted here.
[0235] Figure 9 Schematic diagram of the physical structure of an electronic device provided in an embodiment of the present invention, such as Figure 9 As shown, the present invention provides an electronic device, including: a processor (processor) 901, a memory (memory) 902 and a bus 903;
[0236] The processor 901 and the memory 902 communicate with each other via the bus 903.
[0237] The memory 902 stores program instructions that can be executed by the processor 901. The processor 901 is used to call the program instructions in the memory 902 to execute the methods provided in the above-mentioned method embodiments, for example, including: determining the first tag information as the grouping basis, and grouping and displaying the data entries in the first data entry set according to the grouping basis; wherein the first tag information is determined based on the attribute information of the data entry; there is only one data item corresponding to the first tag information of the data entry in the first data entry set.
[0238] In an embodiment of the present invention, a (non-transitory) computer-readable storage medium is provided. The non-transitory computer-readable storage medium stores computer instructions. The computer instructions enable a computer to execute the methods provided in the above-mentioned method embodiments, for example, including: determining the first tag information as the grouping basis, and grouping and displaying the data entries in the first data entry set according to the grouping basis; wherein the first tag information is determined based on the attribute information of the data entry; there is only one data item corresponding to the first tag information of the data entry in the first data entry set.
[0239] The present invention also provides a computer program product, which includes a computer program stored on a non-transitory computer-readable storage medium, and the computer program includes program instructions. When the program instructions are executed by a computer, the computer can execute the work order priority confirmation method provided by the above methods, and the method includes: determining the first label information as the grouping basis, and grouping and displaying the data entries in the first data entry set according to the grouping basis; wherein the first label information is determined based on the attribute information of the data entry; there is only one data item corresponding to the first label information of the data entry in the first data entry set.
[0240] Those skilled in the art will understand that all or part of the steps of implementing the above-mentioned method embodiment can be completed by hardware related to program instructions, and the aforementioned program can be stored in a computer-readable storage medium. When the program is executed, it executes the steps of the above-mentioned method embodiment; and the aforementioned storage medium includes: ROM, RAM, disk or optical disk, etc. Various media that can store program codes.
[0241] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the various embodiments of the present invention.
Claims
1. A data processing method, characterized in that: include: determining the first tag information as a grouping basis, and grouping and displaying the data entries in the first data entry set according to the grouping basis; Wherein, the first tag information is determined according to the attribute information of the data entry; and there is only one data item corresponding to the first tag information of the data entry in the first data entry set; The first data entry set includes a second data entry, where the second data entry is a plurality of data entries obtained by splitting a plurality of data items corresponding to the first tag information in the first data entry into different data entries, wherein the first tag information in the first data entry corresponds to more than one data item, and the first tag information in the second data entry corresponds to only one data item; Generating corresponding kanban views for the data entries in the first data entry set; grouping the data entries in the first data entry set that have the same data items corresponding to the first tag information; and displaying the kanban views corresponding to the data entries in the same group in the same kanban area; The first data entry is split according to the data item corresponding to the first tag information in the first data entry; homologous identification information is set for the multiple second data entries obtained by the split, and when each kanban view is subsequently deleted or moved, the corresponding attribute information of the original data entry is changed based on the homologous identification information.
2. The data processing method according to claim 1, wherein: The determining the first tag information as a grouping basis, and grouping and displaying the data entries in the first data entry set according to the grouping basis, includes: Determining a second set of data entries based on the first input; wherein a data item of each data entry in the second set of data entries has corresponding attribute information; Based on the second input, each data entry in the second data entry set is traversed, and the first data entry therein is split into multiple second data entries to obtain a first data entry set; based on the first tag information, the data entries in the first data entry set are grouped and displayed.
3. The data processing method according to claim 1, wherein: The step of setting homology identification information for the plurality of second data entries obtained by splitting includes: Setting the same identifier for each of the plurality of second data entries obtained by splitting; Alternatively, associated identifiers are set for each of the multiple second data entries obtained by splitting.
4. The data processing method according to claim 1, wherein: After grouping and displaying the data entries in the first data entry set based on the first tag information, the method further includes: Based on a third input, deleting the first kanban view on the display interface and deleting a third data entry from the first data entry set; wherein the third data entry is the data entry corresponding to the first kanban view; In the first data entry set, determining whether there is another data entry having the same source identification information as the third data entry; In the case that the other data entries exist, the data item corresponding to the first tag information in the third data entry is deleted from the data entry before the third data entry is split.
5. The data processing method according to claim 4, characterized in that: After determining whether there are other data entries in the first data entry set that have the same source identification information as the third data entry, the method further includes: In the absence of the other data entries, if the third data entry is an unsplit data entry, directly delete the third data entry; if the third data entry is a split data entry, delete the data entry before the third data entry is split.
6. The data processing method according to claim 1, wherein: After grouping and displaying the data entries in the first data entry set based on the first tag information, the method further includes: Adjusting the position of the second billboard view according to a movement instruction for the second billboard view on the display interface; According to the adjusted new position of the second kanban view, the data item corresponding to the first tag information in the data entry corresponding to the second kanban view is updated.
7. The data processing method according to claim 6, characterized in that: The adjusting the position of the second signboard view according to the movement instruction for the second signboard view on the display interface, and updating the data item corresponding to the first tag information in the data entry corresponding to the second signboard view according to the new position of the adjusted second signboard view, includes: Based on the fourth input, the second kanban view is moved on the display interface to the location of the third kanban view; wherein the data entry corresponding to the second kanban view is the fourth data entry, and the data entry corresponding to the third kanban view is the fifth data entry; and the fourth data entry and the fifth data entry are not in the same group; determining whether the fourth data entry and the fifth data entry have the same source identification information; In the absence of homology identification information, if the fourth data entry is a data entry obtained by splitting, in the data entry before the fourth data entry is split, the data item corresponding to the first tag information in the fourth data entry is changed to the data item corresponding to the first tag information in the fifth data entry; if the fourth data entry is a data entry that has not been split, in the fourth data entry, the data item corresponding to the first tag information is changed to the data item corresponding to the first tag information in the fifth data entry; The kanban view corresponding to the modified fourth data entry and the third kanban view are set to be displayed in the same kanban area.
8. The data processing method according to claim 7, characterized in that: After determining whether the fourth data entry and the fifth data entry have the same source identification information, the method further includes: In the case of homologous identification information, in the data entry before the fourth data entry is split, merging the data item corresponding to the first tag information in the fourth data entry and the data item corresponding to the first tag information in the fifth data entry; Delete the second Kanban view.
9. A data processing device, characterized in that: include: a grouping display module, configured to determine the first tag information as a grouping basis, and group and display the data entries in the first data entry set according to the grouping basis; wherein the first tag information is determined based on the attribute information of the data entry; the data entry in the first data entry set has only one data item corresponding to the first tag information; the first data entry set includes a second data entry, the second data entry being a plurality of data items obtained by splitting the plurality of data items corresponding to the first tag information in the first data entry into different data entries, wherein the first tag information in the first data entry has more than one data item corresponding to it, and the first tag information in the second data entry has only one data item corresponding to it; Generating corresponding kanban views for the data entries in the first data entry set; grouping the data entries in the first data entry set that have the same data items corresponding to the first tag information; and displaying the kanban views corresponding to the data entries in the same group in the same kanban area; The first data entry is split according to the data item corresponding to the first tag information in the first data entry; homologous identification information is set for the multiple second data entries obtained by the split, and when each kanban view is subsequently deleted or moved, the corresponding attribute information of the original data entry is changed based on the homologous identification information.
10. An electronic device, characterized in that: include: processor, memory, and bus, wherein, The processor and the memory communicate with each other via the bus; The memory stores program instructions that can be executed by the processor, and the processor can execute the steps of the data processing method according to any one of claims 1 to 8 by calling the program instructions.
11. A computer-readable storage medium, characterized in that The computer-readable storage medium stores computer instructions, and the computer instructions enable the computer to execute the steps of the data processing method according to any one of claims 1 to 8.
Citation Information
Patent Citations
Data screening statistical method, device, electronic device and storage medium
CN109325218A
System and method for integrating spreadsheets and word processing tables
US20050050088A1
Techniques for query and DML over relational tables using spreadsheet applications
US20090158251A1
Harvesting relational tables from lists on the web
US8140533B1