topic Re: [resolved] Variable increment in Talend Studio

[resolved] Variable increment

Anonymous — Wed, 15 Apr 2015 22:20:49 GMT

hi,
i want to create a new column in my database with the type (integer).
For this i want to create a variable which increment of 1 everytime my job run.
Example :
1- First execution : the field takes the value 0
2-Second executon : the field takes the value 1
.
.
12-// // : the field takes the value 11
any idea?
thanks

Re: [resolved] Variable increment

Anonymous — Thu, 16 Apr 2015 09:23:53 GMT

after execution write current value to file.
on next execution read this value from file and increment it.(then write to file)
or when you execute your job, read max value from database(if not found, write 0), increment it and write to database

Re: [resolved] Variable increment

Anonymous — Thu, 16 Apr 2015 17:26:37 GMT

thx jetab , i understund your idea but how to do it really in talend ? i'm really new using talend ...

Re: [resolved] Variable increment

Anonymous — Fri, 17 Apr 2015 14:10:00 GMT

Your job should be something like this: Take Row count from your desired DB if its is zero give the JobCountRun Value as zero esle fetch the last saved jobCountRun Value and add by 1 and fed it to a context value, OnSubJobOk fetch the context value into DB as well as into a file from where you could fetch the JobCountRun which should be the JobCountRun value. In this way u can create and save a JobCountRun value into your DB whenever you Run your job multiple times.

Re: [resolved] Variable increment

Anonymous — Tue, 21 Apr 2015 11:27:12 GMT

thx for your reply . It works