User Tools

Site Tools


transformations:select

Differences

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

Link to this comparison view

Last revisionBoth sides next revision
transformations:select [2014/10/25 18:32] – created dmitrytransformations:select [2015/04/10 15:28] elenap
Line 1: Line 1:
 ===== Select Columns ===== ===== Select Columns =====
  
-This transformation removes all columns but selected.+This transformation removes all columns except the selected ones. 
 + 
 +EXAMPLE 
 + 
 +**Source table:** The longest rivers in the world 
 + 
 +^  River  ^  Length (km)  ^  Length (miles)  ^  Continent 
 +| Nile  |  6650  |  4132  |  Africa 
 +| Amazon  |  6400  |  3976  |  South America 
 +| Yangtze  |  6300  |  3917  |  Asia  | 
 +| Mississippi  |  6275  |  3902  |  North America 
 + 
 + 
 +**Objective:** Keep the first two columns in the table. Remove all other columns. 
 + 
 +**Transformation parameters:** 
 + 
 +  * Columns to select: River; Length (miles) 
 +   
 +**Output table:** 
 + 
 +^  River  ^  Length (km)  ^ 
 +| Nile  |  6650  | 
 +| Amazon  |  6400  | 
 +| Yangtze  |  6300  | 
 +| Mississippi  |  6275  | 
 + 
 +=== See also === 
 +  * [[transformations:remove|Remove Columns]]
transformations/select.txt · Last modified: 2015/04/10 15:29 by elenap

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki