We need to write a sequential number in some output records. We've tried to use the index function but every time that we switch from one functional map to another it restart from 1.
We need a global variable that allow us to number all the records across functional maps
Thanks for your help
Re: Output index2012-12-11T18:12:07ZThis is the accepted answer. This is the accepted answer.You may be able to pass the index value between functional maps and then just add it to the current INDEX() value. For example, your FMap might look like:
FMap(Object1, Object2, Index, INDEX())
Your map rule might be:
SequentialNumber=PreviousIndex + CurrentIndex
Look up the LAST function to see if it might be of use.
"Using LAST in a map rule to reference an output
In a map rule, when referencing an output, LAST refers to the last built occurrence of that object. For example, using the same expression:
PO# Field:Order = PO# Field:OrderLAST
LAST refers to the previous occurrence of Order because, when this rule is evaluated, the last known Order is the last one built.
LAST is a reserved word and is not case sensitive."