Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |
| transformations:fillgaps [2021/04/05 02:30] – craigt | transformations:fillgaps [2021/07/18 01:36] (current) – craigt |
|---|
| > Select "Country" column. | > Select "Country" column. |
| \\ | \\ |
| **Output:** | **Result table:** |
| |
| ^ Country ^ State/ Province ^ | ^ Country ^ State/ Province ^ |
| > Group by "Last Name" and "Position" columns | > Group by "Last Name" and "Position" columns |
| \\ | \\ |
| **Output:** | **Result table:** |
| ^Row Num ^First Name ^Last Name ^Position ^ | ^Row Num ^First Name ^Last Name ^Position ^ |
| | 1|Bob |Wilson |Admin | | | 1|Bob |Wilson |Admin | |
| * No value is filled in row 5 as there is no Last Name = "Wainright" and Position = "Accountant" record //prior// to the empty cell. (The First Name of "Roger" - row 8 - falls //after// the empty value - row 5.)\\ | * No value is filled in row 5 as there is no Last Name = "Wainright" and Position = "Accountant" record //prior// to the empty cell. (The First Name of "Roger" - row 8 - falls //after// the empty value - row 5.)\\ |
| |
| | \\ |
| | ====Community examples==== |
| | * [[https://community.easymorph.com/t//1686/2|Aggregation of consecutive date ranges]] ([[https://community.easymorph.com/uploads/short-url/xyC5nPd52hGrMiRXjp5w1RVUTYL.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Easymorph Patient Example Data.xlsx//;\\ Action position: //9//) |
| | * [[https://community.easymorph.com/t//2275/2|Data on multiple rows from Excel file]] ([[https://community.easymorph.com/uploads/short-url/xmZfLPwSmGmm6WmlLRV2XkCKAo4.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Book1.xlsx//; Action position: //2//) |
| | * [[https://community.easymorph.com/t//1972/2|Read Data with two line header]] ([[https://community.easymorph.com/uploads/short-url/4YFQxslIv3pmgtF2eRywf4wpcFQ.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Read, Mark groups//; Action position: //6//) |
| |
| \\ | \\ |
| =====See also===== | =====See also===== |
| * [[transformations:fillright|Fill right]] | * [[transformations:fillright|Fill right]] |
