sequence

[Anonymous]

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)

[Anonymous]

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

 

[Anonymous]

could please explain in detail

[Anonymous]

please provide one example job design

[Anonymous]

Hello,

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

best regards

Sabrina

[Anonymous]

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

[Anonymous]

actually i want 7 after 6

[Anonymous · Accepted solution]

@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