CPC G06F 16/258 (2019.01) [G06F 16/2282 (2019.01)] | 20 Claims |
1. A computer-implemented method comprising:
receiving an indication to generate a pivot table from an existing table in a software application or service;
determining a plurality of fields included in the existing table to populate the pivot table with;
arranging, in memory, the plurality of fields in a first order;
arranging an order of the plurality of fields from the first order to a semantic hierarchical order based on a set of cardinality relationship rules;
identifying a plurality of blocks included in the plurality of fields in the semantic hierarchical order;
generating the pivot table with the plurality of fields, wherein the generating comprises:
populating columns in the pivot table from fields included in one or more blocks of the plurality of blocks that have a cardinality value less than a threshold cardinality value, and
populating rows in the pivot table from fields included in one or more blocks of the plurality of blocks that have a cardinality value that meets or exceeds the threshold cardinality value; and
rendering the pivot table in the software application or service.
|