I'd like to assign a numeric value to records in a result set in sequential order. I can't use the "Sequential Value" that Boomi provides out of the box, because I need it to reset. See:Reset Sequential value
i.e. If I query 10 records from my SQL database, I'd like to assign a numeric Dynamic Document Property to each of the records starting with 1. I use that later in a decision step in order to filter out duplicate 'Load from Cache'. Is there a way to do this without using scripting?
I tried using a map function with Line Item Increment but that doesn't seem to work when counting separate documents, rather it counts a specific instance of a field.