Talend increment counter

counter talend
JMira picture JMira · Mar 4, 2011 · Viewed 16.3k times · Source

I'm making a ETL in Talend that add data in a table.

The table is for a old system and the primary key is not auto-incremental. So I have to get the maximum id plus one every time that I insert a value in the table.

I'm trying to use a var in the Expression Builder:

  • first I save the max and set in a context variable

  • then in the Expression Builder:

    Context.Max += 1

The problem is that every time I get the same id, I need to save the sum.

Answer

JMira picture JMira · Mar 4, 2011

Finally I found what was looking for:

Numeric.sequence("var2", Context.Max, 1)

This increment by 1 the Context.Max and save it in "var2".

Related questions

How to count the frequency of the elements in an unordered list?

I need to find the frequency of elements in an unordered list a = [1,1,1,1,2,2,2,2,3,3,4,5,5] output-> b = [4,4,2,1,2] Also I want to remove the duplicates from a a = [1,2,3,4,5]

Read More
Get loop counter/index using for…of syntax in JavaScript

Caution: question still applies to for…of loops.> Don't use for…in to iterate over an Array, use it to iterate over the properties of an object. That said, this I understand that the basic for…in syntax in …

Read More
Counter increment in Bash loop not working

I have the following simple script where I am running a loop and want to maintain a COUNTER. I am unable to figure out why the counter is not updating. Is it due to subshell thats getting created? How can …

Read More