topic Re: sequence in Talend Studio

sequence

Anonymous — Thu, 29 Nov 2018 17:16:58 GMT

my requirement is i created two output flows in tmap each flow sequence generated like("s1",1,1)i want 1-6 in first(6 records are there)

another flow also ("s1",1,1)7-10 in this( 3 records in this)

Re: sequence

Anonymous — Fri, 30 Nov 2018 03:10:34 GMT

Hello,

You can achieve this Auto-Increment in tMap.

Please create a variable (var1) with this expression :Var.var1==0 || Var.var1>=6 ? 1 : Var.var1+1

Let us know if it is OK with you.

Best regards

Sabrina

Re: sequence

Anonymous — Fri, 30 Nov 2018 04:15:42 GMT

could please explain in detail

Re: sequence

Anonymous — Fri, 30 Nov 2018 04:23:14 GMT

please provide one example job design

Re: sequence

Anonymous — Fri, 30 Nov 2018 06:07:58 GMT

Hello,

I will create a demo job and them come back to you as soon as I can.

best regards

Sabrina

Re: sequence

Anonymous — Fri, 30 Nov 2018 07:28:38 GMT

Hello,

Could you please take a look at my screenshots for details?

Feel free to let us know if it is what you are looking for.

Best regards

Sabrina

Re: sequence

Anonymous — Mon, 10 Dec 2018 09:59:44 GMT

actually i want 7 after 6

Re: sequence

Anonymous — Mon, 10 Dec 2018 10:21:29 GMT

@rchinta

If you are looking for second sequence to start with last number of first sequence, below are the steps.

a) Generate the first sequence in normal fashion eg ("s1",1,1)

b) Pick the last value of current sequence (or after tmap, do a max of sequence id) and store in a context variable (context.last_seq_max_number) with integer data type

c) In the next sequence, use ("s2",context.last_seq_max_number,1)

Now the second sequence will start with 7.

Hope I have answered your query. I would suggest you to create a sample job and test the steps yourself to practice your learnings. Could you please mark the topic as resolved since the query has been answered now? Kudos are also welcome 🙂

Warm regards,

Nikhil Thampi