When you work with the spreadsheet data, often you need to combine data from multiple sheets. esCalc provides several operations, including join and union, to do this.
1. Join operation
With esCalc, you can perform the join operation to import data from one esCalc sheet into the other according to the primary ke...
2015-10-27 45 0
During data analysis and computing with spreadsheets, you often need to group data according to the computing target. For example, group order records by clients or the manufacturing data by months. In an esCalc spreadsheet, you can use the group operation to divide bands into different groups according to values of ho...
2015-10-23 42 0
With a spreadsheet, often we need to re-sort data we work with to make it more organized according to the computing target. An esCalc sort operation can sort data efficiently. At times the desired order is not a simple ascending or descending order. In those cases the align operation can be used to sort data in a speci...
2015-10-20 62 0
Locating desired data and filtering data to delete or hide the unwanted data are common data manipulation operations on a worksheet. esCalc offers locate operation to find the homo-cells satisfying your criteria in a sheet and filter operation to filter away the homo-bands that don’t satisfy them. Here we’ll focus our ...
2015-10-12 39 0
Data in an esCalc worksheet is stored in hierarchical bands, allowing it to be analyzed through various operations such as grouping, filtering and sorting. This article deals with row expansion. The expand operation allows you to make copies of a record based on a sequence-type cell value. It is used to complete data e...
2015-10-10 40 0