transformations:fillgaps
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:fillgaps [2018/07/21 11:32] – dmitry | transformations:fillgaps [2021/07/18 01:36] (current) – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Fill gaps ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Advanced\\ | ||
- | This transformation | + | \\ |
- | The cells get filled downwards. | + | =====Description===== |
+ | This action | ||
- | EXAMPLE | + | \\ |
+ | =====Use cases===== | ||
+ | * To fill gaps that may be inherent in an imported outlined or hierarchical data structure. | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting ^Description ^ | ||
+ | |Fill gaps in selected columns|Select one or more columns to fill empty cells within.| | ||
+ | |Group by selected columns|Select the column(s) where matching values will determine what the source value is to fill in.| | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Example 1:** Add the name of the country in the empty cells of the column " | ||
**Table:** Countries and States/ Provinces | **Table:** Countries and States/ Provinces | ||
^ Country | ^ Country | ||
- | | Canada | + | |Canada |
- | | | British Columbia | + | | |British Columbia |
- | | | Manitoba | + | | |Manitoba |
- | | USA | Alabama | + | |USA |Alabama |
- | | | Alaska | + | | |Alaska |
- | | | Arizona | + | | |Arizona |
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Select " | ||
+ | \\ | ||
+ | **Result table:** | ||
- | **Objective:** Add the name of the country | + | ^ Country |
+ | |Canada | ||
+ | |Canada | ||
+ | |Canada | ||
+ | |USA |Alabama | ||
+ | |USA |Alaska | ||
+ | |USA |Arizona | ||
+ | \\ | ||
+ | \\ | ||
+ | **Example 2:** Fill in empty cells in "First Name" based on the values in "Last Name" and " | ||
- | **Transformation:** Select the column and calculate. | + | **Table:** Staff positions |
- | **Result:** | + | ^Row Num ^First Name ^Last Name ^Position |
+ | | 1|Bob |Wilson |Admin | | ||
+ | | 2| |Wilson |Admin | | ||
+ | | 3|Lisa |Smith |CEO | | ||
+ | | 4|Darci |Wilson |Accountant | | ||
+ | | 5| |Wainright |Accountant | | ||
+ | | 6|Tony |Smith |Accountant | | ||
+ | | 7| |Smith |Accountant | | ||
+ | | 8|Roger |Wainright |Accountant | | ||
+ | | 9| |Smith |Custodial | | ||
+ | | 10| |Wilson |Admin | | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Fill gaps in "First Name" column | ||
+ | > Group by "Last Name" and " | ||
+ | \\ | ||
+ | **Result | ||
+ | ^Row Num ^First Name ^Last Name ^Position | ||
+ | | 1|Bob |Wilson |Admin | | ||
+ | | 2|Bob |Wilson |Admin | | ||
+ | | 3|Lisa |Smith |CEO | | ||
+ | | 4|Darci |Wilson |Accountant | | ||
+ | | 5| |Wainright |Accountant | | ||
+ | | 6|Tony |Smith |Accountant | | ||
+ | | 7|Tony |Smith |Accountant | | ||
+ | | 8|Roger |Wainright |Accountant | | ||
+ | | 9| |Smith |HR Manager| | ||
+ | | 10|Bob |Wilson |Admin | | ||
- | ^ Country | + | * " |
- | | Canada | + | |
- | | Canada | + | |
- | | Canada | + | |
- | | USA | + | \\ |
- | | USA | + | ====Community examples==== |
- | | USA | Arizona | + | |
+ | | ||
+ | | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | |
transformations/fillgaps.1532187121.txt.gz · Last modified: 2018/07/21 11:32 by dmitry