Use Roll Forward Logic
- 02 Jun 2023
- 1 Minute to read
- Contributors
- Print
- DarkLight
- PDF
Use Roll Forward Logic
- Updated on 02 Jun 2023
- 1 Minute to read
- Contributors
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
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 |
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 | - | - |
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).
Was this article helpful?