topic Re: Numeric sequence reset in Talend Studio

Numeric sequence reset

_AnonymousUser — Sat, 16 Nov 2024 14:18:24 GMT

Hello,
i am using a variable inside a tMap like this ---> Numeric.sequence("s1",1,1) * 10
so for each record processed i get 10, 20 ,30 and so on
the problem is that i need to reset this sequence each time i launch the job...
when launching the job from inside talend, the sequence is correctly resetted but if i export my job as
webservice, the sequence never resets.
is it possible to resolve this problem? Thanks in advance.

Re: Numeric sequence reset

_AnonymousUser — Thu, 10 Jul 2008 09:35:46 GMT

can anyone help?

Re: Numeric sequence reset

_AnonymousUser — Fri, 11 Jul 2008 10:58:27 GMT

Re: Numeric sequence reset

amaumont — Fri, 11 Jul 2008 12:39:55 GMT

I suggest you to add a feature to improve it.
Yet, you can duplicate Numeric routine and add a method such as:

    public static void resetSequence(String seqName, int startValue) {
        seq_Hash.put(seqName, startValue);
    }

Re: Numeric sequence reset

_AnonymousUser — Fri, 11 Jul 2008 15:48:55 GMT

thanks a lot, it worked!
i created a new Routine, i copied Numeric routine code and i added this method:
public static void resetSequence(String seqName){
seq_Hash.put(seqName, 0);
}
Then i call the method from a tava component. Thanks again for your answer

Re: Numeric sequence reset

amaumont — Fri, 11 Jul 2008 16:00:41 GMT

Please create a feature to improve the product even this method works, it will improve the product for the next release, thank you.

Re: Numeric sequence reset

Anonymous — Thu, 03 Jun 2010 12:28:36 GMT

When I try to install this routine, the "seq_Hash.put(seqName, 0);" part get's red-underlined. seq_Hash in particullar.. Any ideas why my TIS 3.2 doesn't have that Java class? Is there any particullar class I need to import on the top of the routine package??
Help would be much appreciated.

Re: Numeric sequence reset

_AnonymousUser — Fri, 11 Mar 2011 16:44:33 GMT

You should copy sequence related code from Numeric system routine, add new method and use your routine instead of system.

Re: Numeric sequence reset

Anonymous — Wed, 13 Apr 2016 17:25:33 GMT

This may be an old post, but it saved my days of work. Thanks to all that contribute back to the forum.

Re: Numeric sequence reset

Anonymous — Wed, 20 Apr 2016 08:57:46 GMT

There's a function to do this now.

Re: Numeric sequence reset

talendtester — Wed, 20 Apr 2016 15:16:47 GMT

Do you want to help people by posting the function?

Re: Numeric sequence reset

Anonymous — Thu, 21 Apr 2016 10:16:58 GMT

It's in the Numeric system routine at 5.6.2