EasyMorph Help

User Tools

Site Tools

You are here: start » transformations » aggregate
transformations:aggregate

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
transformations:aggregate [2021/04/02 01:47] – craigttransformations:aggregate [2021/07/18 00:48] – craigt
Line 43: Line 43:
 | Ob  |  5410|Asia  | | Ob  |  5410|Asia  |
 | Paraná  |  4880|South America  | | Paraná  |  4880|South America  |
 +\\ 
 **Action parameters:** **Action parameters:**
- 
 >Calculate: Length(km), Aggregation: Max >Calculate: Length(km), Aggregation: Max
 >Group by: Continent >Group by: Continent
- +\\  
-**Output table:** +**Result table:**
 ^Continent  ^Max of Length(km)  ^ ^Continent  ^Max of Length(km)  ^
 |Africa  |  6650| |Africa  |  6650|
Line 61: Line 59:
 **Example 2:** Find out the longest river, and the number of rivers, on each continent. **Example 2:** Find out the longest river, and the number of rivers, on each continent.
  
-**Source table:** Same source table as Example 1. +**Source table:** Same source table as Example 1.\\ 
 +\\ 
 **Action parameters:** **Action parameters:**
- 
 >Calculate: Length(km), Aggregation: Max >Calculate: Length(km), Aggregation: Max
 >Calculate: River, Aggregation: Count >Calculate: River, Aggregation: Count
 >Group by: Continent >Group by: Continent
- +\\  
-**Output table:** +**Result table:**
 ^Continent^Max of Length(km)^Count of River^ ^Continent^Max of Length(km)^Count of River^
 |Africa  |  6650|  1| |Africa  |  6650|  1|
Line 77: Line 73:
 |South America  |  6400|  2| |South America  |  6400|  2|
  
 +\\ 
 +====Community examples====
 +  * [[https://community.easymorph.com/t//675/5|Compare two Excel sheets with EasyMorph]] ([[https://community.easymorph.com/uploads/short-url/xQLWtAogCqcMrglyfXLKmrAF7aR.morph|Project]]; Module: //Main//; Group: //Compare column names//; Table: //Actual columns list//;\\ Action position: //3//)
 +  * [[https://community.easymorph.com/t//1357/2|Generate CommaSeparated Fieldlist]] ([[https://community.easymorph.com/uploads/short-url/7BiLOXdlQxZWOEOqIwfASApQern.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //4//)
 +  * [[https://community.easymorph.com/t//1652/2|Which technique for grouping many columns of data together (i.e. 50+ columns)]] ([[https://community.easymorph.com/uploads/short-url/ub3zV5WsGF4rWqJQMb7oEtPReqy.morph|Project]]; Module: //Main//; Group: //Tab 1//;\\ Table: //Aggregate//; Action position: //2//)
 +  * [[https://community.easymorph.com/t//1778/2|Aggregate for +500 columns]] ([[https://community.easymorph.com/uploads/short-url/8w0FN8IXxRdEIORedS9u8DKqhfA.morph|Project]]; Module: //Main//; Group: //Order preserved//; Table: //Book1.xlsx(2)//; Action position: //3//)
 +  * [[https://community.easymorph.com/t//2321/4|Collapsing multiple rows into one]] ([[https://community.easymorph.com/uploads/short-url/j6CBEKHa76q1v9oQqui4UPWN7ro.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Method 2//; Action position: //2//)
  
 \\  \\ 
Line 88: Line 91:
 =====See also===== =====See also=====
   * [[transformations:addcolumn|Calculate new column(s)]]   * [[transformations:addcolumn|Calculate new column(s)]]
-  * [[transformations:replacecolumn|Modify columns(s)]]+  * [[transformations:replacecolumns|Modify columns(s)]]
   * [[transformations:Rule|Rule]]   * [[transformations:Rule|Rule]]
  
  
transformations/aggregate.txt · Last modified: 2021/09/12 11:25 by craigt
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki