When Roll Forward logic is enabled and unique fields are set during harvesting, Mozenda will overwrite empty values in non-unique fields with the most recently captured non-empty values. If Store Item History is enabled, this feature will also look back to the most recent previous run for the matching unique row and pull non-empty values forward.
For example, given the following rows of data (where ID is the unique field):
| Created | ItemID | ID | Full Name | Sex | Occupation |
|---|---|---|---|---|---|
| 2019-12-20 00:01:22 | 1001 | 1234 | John Smith | M | - |
| 2019-12-20 01:00:12 | 1002 | 1234 | John Smith | - | Explorer |
| 2019-12-20 01:30:54 | 1003 | 1234 | John Smith | - | - |
With Roll Forward logic activated during harvesting, they would be combined into:
| Created | ItemID | ID | Full Name | Sex | Occupation |
|---|---|---|---|---|---|
| 2019-12-20 00:01:22 | 1001 | 1234 | John Smith | M | Explorer |
Without Roll Forward logic activated during harvesting, they would be combined into:
| Created | ItemID | ID | Full Name | Sex | Occupation |
|---|---|---|---|---|---|
| 2019-12-20 00:01:22 | 1001 | 1234 | John Smith | - | - |
Note
Roll Forward logic can't be applied to previous or active runs. Make sure to apply Roll Forward logic before you schedule or manually run your agent(s).