User Tools

Site Tools


transformations:fillgaps

Fill 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.txt · Last modified: 2018/07/21 15:32 by dmitry