7 results about "Pivot table" patented technology

Embodiments of the disclosure disclose a method, apparatus and electronic device for data querying. The method includes: traversing data records of a target data source; for each target data record, obtaining, based on an aggregation basis dimension of the target data source, a target aggregation basis path corresponding to the target data record, and updating, based on dimension types and dimension values of the target data record in aggregate computation dimensions, summarized values, corresponding to a plurality of summary types, of the target aggregation basis path in the aggregate computation dimensions in a data pivot table of the target data source; and after the data records of the target data source are traversed, performing a data pivot service of the target data source based on the data pivot table.

The application discloses a kind of based on RPA realization Excel data pivot table pickup method, including RPA robot, including the following steps: S1, application RPA robot reads the data pivot table in original Excel;S2, data pivot table is set event listening;S3, return to original Excel and click data pivot table relevant area, obtain the entire data pivot table of this sheet, then determine the data pivot table object selected currently;S4, according to data pivot table object, the encoding information of data pivot table is loaded into the program of RPA robot;S5, using RPA robot, the pivot table setting rule corresponding to encoding information is applied to current Excel object.The present application can obtain existing data pivot table configuration information, and then be applied to other arbitrary Excel by RPA robot, improve the automation execution efficiency of RPA.

The application discloses a processing method and device of a pivot table, electronic equipment and a readable storage medium, and the method comprises the following steps: acquiring a pivot table, wherein the pivot table has one numerical field and at least two row and column fields; generating a corresponding data cross table according to the row and column fields; and generating a source data table of a visual analysis result of the pivot table according to the data cross table.

The disclosed technology creates a range of manual to automated ways of setting up and verifying the correct joining of data sets for use generating spreadsheet pivot tables. Handling pairing of data sets and then chaining / sequencing of joins resulting in joins of three or more data sets. Limiting joins to keys with matching data types and matching data values. Limiting joins, as desired, to data value matching criteria and data modelling cardinality requirements. Allowing the qualification of the data sets for joining to be done within or before spreadsheet pivot input panel. Making the qualified joinable data sets available in situationally intelligent data field / range selection lists for use populating the pivot table inputs. Availing those joined data fields / ranges to be used to generate spreadsheet pivot tables.

Described are systems and methods for rendering a three-dimensional (3D) pivot table that can be embedded in a spreadsheet. A data structure underlying the 3D pivot table contains raw data organized in arrays that can be depicted as two-dimensional (2D) tables. A rendering system combines some or all of the 2D tables into a 3D rendering of a pivot table in which each of the combined sides represents a visible face of the 3D pivot table. A user can split the rendered 3D pivot table along one or three axes to expose internal data elements for viewing or editing. Changes to the values of internal data elements impact values presented in the visible faces of the 3D pivot table.

The present disclosure provides a data processing method, device and electronic equipment, a specific embodiment of the method includes: obtaining a plurality of filtering conditions for filtering data in a target data table and a logical relationship between the plurality of filtering conditions; determining a first value corresponding to each filtering condition in the plurality of filtering conditions, the first value corresponding to any filtering condition being determined by at least one first record obtained according to the filtering condition; performing a logical operation based on the first value and the logical relationship between the plurality of filtering conditions to determine a target record to generate a pivot table. This embodiment can simplify the process of generating a pivot table and improve the speed of generating a pivot table.

The invention provides a real-time perspective table generation method and system based on dynamic dimension constraint in the technical field of perspective table generation, and the method comprises the steps: S1, reading dimension data and index data from a database, and displaying the dimension data and the index data in a tree structure in a data source region; s2, dragging the dimension data or the index data of the data source area to a data display area for display; s3, carrying out attribute configuration on the dimension data and the index data in the data display area; s4, performing data analysis operation on the dimension data and the index data in the data display area to obtain a data analysis result; s5, configuring the operation authority of the perspective table; and step S6, rendering the dimension data, the index data and the data analysis result in the data display area by the perspective table configuration interface, and outputting and displaying the generated perspective table. The method has the advantages that the efficiency, the flexibility and the real-time performance of perspective table generation are greatly improved.