I'm trying to do a transform where 2 integer values are subtracted from 2 different records that each have a unique ID. Each record contains a value, a unique ID referencing itself, and an ID referencing another record. To get the second number for subtraction, I need to loop through all incoming records to find the record that whose ID is referenced. After finding this record, I need to be able to update its existing value by subtracting the previous record's value from it.
Logically, this would work like a double for-loop. I've tried doing this in the map component, but that component seems to only manipulate 1 record at a time without being able to loop though all incoming records again and dynamically changing a different record's value. Is there a way/component that is able to do this?
Please sign in to leave a comment.