transformations:fillgaps
This is an old revision of the document!
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.1430498398.txt.gz · Last modified: 2015/05/01 12:39 by elenap