User Tools

Site Tools


transformations:aggregate

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
transformations:aggregate [2015/04/27 19:51] elenaptransformations:aggregate [2015/05/01 08:49] dmitry
Line 25: Line 25:
 | Paraná  |  4880  |  South America  | | Paraná  |  4880  |  South America  |
  
-**Objective:** Find out which are the longest rivers on each continent.+**Objective:** Find out the longest river on each continent.
  
 **Transformation parameters:** **Transformation parameters:**
Line 31: Line 31:
   * Calculate: Length(km)      * Calculate: Length(km)   
   * Aggregation: Max   * Aggregation: Max
-  * Group by: Continent; River+  * Group by: Continent
  
 **Output table:** **Output table:**
Line 37: Line 37:
 ^  River  ^  Continent  ^  Max of Length(km)  ^ ^  River  ^  Continent  ^  Max of Length(km)  ^
 | Nile  |  Africa  |  6650  | | Nile  |  Africa  |  6650  |
-| Ob  |  Asia  |  5410  | 
 | Yangtze  |  Asia  |  6300  | | Yangtze  |  Asia  |  6300  |
-| Yellow River  |  Asia  |  5464  | 
-| Yenisei  |  Asia  |  5539  | 
 | Mississippi  |  North America  |  6275  | | Mississippi  |  North America  |  6275  |
 | Amazon  |  South America  |  6400  | | Amazon  |  South America  |  6400  |
-| Paraná  |  South America  |  4880  | 
  
transformations/aggregate.txt · Last modified: 2021/09/12 11:25 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki