AnsweredAssumed Answered

Assign Numeric Value to Queried Documents (Records)

Question asked by YechielKaplan8651 on Oct 28, 2016
Latest reply on Oct 31, 2016 by YechielKaplan8651

Hey everyone,

 

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.

Outcomes