Sequence not starting from previous value

[Anonymous]

Hi,

I'm trying to generate the sequence number for each newly inserted value. But when i'm inserting new records and run the job again, the sequence starts from 1 for the new values but not from the previous (max) value.

This is the expression i have used  "Numeric.sequence("s2",(row5.id == null?1:row5.id)+1,1)  ", where row5.id is the max id from aggregaterow component.

Please find the attached screenshot for reference.

Thanks

[Anonymous]

Sorry, 

But I have a global variable set and then I want to use it in tMap component through a sequence:

- Component tSetGlobalVar: globalMap.get("maxNegoId") 

-tMap Expresion for an output column: Numeric.sequence("s1",(Integer)globalMap.get("maxNegoId",1)) 

But the system gives error: The method get(Object) in the type Map>String.Object> is not applicable for the arguments (String, int)

Can you please help me to resolve it?

Thanks