Roll Forward Logic

March 12, 2020

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, we would just take the values from the most recent row:

Created ItemID ID Full Name Sex Occupation
2019-12-20 00:01:22 1001 1234 John Smith

 

Need more information?

We'd love to hear from you.

100% Privacy. You are that important to us. Privacy Policy