topic Re: [resolved] How do you use Numeric.sequence("s1",1,1) in Talend Studio

[resolved] How do you use Numeric.sequence("s1",1,1)

_AnonymousUser — Sat, 16 Nov 2024 13:57:54 GMT

I want to populate a field in a table with an integer. I want it to increment each time I run the job. This will be my Load Id.
I am thinking of using the Numeric.sequence() function, but I can not find any documentation on how it works or what the parameters do.
Can anyone point me to the documentation that describes this function?
If there is a better way to achieve my desired result, I would be open to suggestions.
Thank You,
Jason

Re: [resolved] How do you use Numeric.sequence("s1",1,1)

Anonymous — Mon, 11 May 2009 03:37:13 GMT

Hello
It is the method defined by Talend, you can go to Repository-->code-->system-->Numeric and read the relate d description of function.
Best regards

shong

Re: [resolved] How do you use Numeric.sequence("s1",1,1)

Anonymous — Thu, 20 May 2010 10:17:18 GMT

Hi,
i use Numeric.sequence("s1",1,1) as an autoincrement ID within one launch (so each row +1) - but now i need an auto-incremented ID for each time i launch the whole job (for the same job ID: 1 - the next time i launch the job ID: 2 a.s.o). Is this possible?
regards
alex

Re: [resolved] How do you use Numeric.sequence("s1",1,1)

alevy — Mon, 07 Jun 2010 01:09:10 GMT

Only by reading back the last ID used from your file/DB at the start of your job and storing it in globalMap so it can be used as the seed in tMap.

Re: [resolved] How do you use Numeric.sequence("s1",1,1)

Anonymous — Fri, 01 Jul 2011 09:57:01 GMT

Hi Alevy,
I am using file as my output. How can I get the max id (last inserted id) from file? Then I can store it in globalMap as used for next execution.

Thanks,
Raja K

Re: [resolved] How do you use Numeric.sequence("s1",1,1)

alevy — Sat, 02 Jul 2011 07:43:09 GMT

If the file is in the order of ID, you can read the file and send the flow to tSetGlobalVar. That way the last record (with the max id) will be stored in the globalMap. You can then use it+1 as the seed for Numeric.sequence.
If the file is not in order, use tAggregateRow to get the max id and then tSetGlobalVar to store it.

Re: [resolved] How do you use Numeric.sequence("s1",1,1)

Anonymous — Mon, 04 Jul 2011 05:57:04 GMT

Thank You so much for your reply. It works for me.

thanks,
Raja K

Re: [resolved] How do you use Numeric.sequence("s1",1,1)

_AnonymousUser — Wed, 22 Apr 2015 14:10:49 GMT

Hi,
I want to add an Batch_ID to my job which runs daily. But this Batch ID should be unique for each run and needs to be incremental.
I created a variable which converts my job run start date into integer and gives me output in form of "yyyyMMdd". Now I want to add a unique number in front of this "yyyyMMdd", so that it serves as a BATCH_ID for that particular run. Point to be noted is, it should add only one number in front of "yyyyMMdd" for each run of the job, and should be incremental for the subsequent runs. I hope i have written my query very clearly.
I willbe grateful if someone could help me out.

Re: [resolved] How do you use Numeric.sequence("s1",1,1)

Anonymous — Wed, 22 Apr 2020 17:30:57 GMT

Hi, I'm facing the same problem.
For me, I'm trying to use Numeric.sequence() thinking in performance. My table will be huge in the future, and the max(id) will be more and more hard to extract.