User Tools

Site Tools


transformations:fillgaps

Differences

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

Link to this comparison view

Next revision
Previous revision
Next revisionBoth sides next revision
transformations:fillgaps [2015/05/01 11:56] – created elenaptransformations:fillgaps [2015/05/01 13:16] elenap
Line 1: Line 1:
 +===== Fill the gaps =====
 +
 This transformation fills the empty cells in selected columns by duplicating the value of a cell above the empty ones.  This transformation fills the empty cells in selected columns by duplicating the value of a cell above the empty ones. 
 The cells get filled downwards.   The cells get filled downwards.  
  
-**Example:**+EXAMPLE
  
-Table: Countries and States/ Provinces+**Table:** Countries and States/ Provinces
  
 ^  Country  ^  State/ Province  ^ ^  Country  ^  State/ Province  ^
Line 16: Line 18:
 **Objective:** Add the name of the country in empty cells of the column "Country". **Objective:** Add the name of the country in empty cells of the column "Country".
  
-**Transformation:** this transformation has no parameters+**Transformation:** Select the column and calculate
  
 **Result:** **Result:**
transformations/fillgaps.txt · Last modified: 2021/07/18 01:36 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki