transformations:fillgaps
This is an old revision of the document!
Fill the gaps
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.
EXAMPLE
Table: Countries and States/ Provinces
| Country | State/ Province |
|---|---|
| Canada | Alberta |
| British Columbia | |
| Manitoba | |
| USA | Alabama |
| Alaska | |
| Arizona |
Objective: Add the name of the country in empty cells of the column "Country".
Transformation: Select the column and calculate.
Result:
| Country | State/ Province |
|---|---|
| Canada | Alberta |
| Canada | British Columbia |
| Canada | Manitoba |
| USA | Alabama |
| USA | Alaska |
| USA | Arizona |
transformations/fillgaps.1430500606.txt.gz · Last modified: 2015/05/01 13:16 by elenap