topic Re: Numeric sequence based on certain data in Talend Studio

Numeric sequence based on certain data

Anonymous — Wed, 13 Nov 2013 17:22:24 GMT

Re: Numeric sequence based on certain data

Anonymous — Thu, 14 Nov 2013 02:44:35 GMT

Hi,
Use below expression in tMap Var section:

Numeric.sequence(row1.Invoice_Num,1,1)

.
Best regards
Sabrina

Re: Numeric sequence based on certain data

Anonymous — Thu, 14 Nov 2013 10:44:15 GMT

Hi Sabrina.
Thanks for your quick reply.
Your solution was the solution that I was trying and now it is working because db type now is int. Was a string before.
My mistake.
Now I have other issue.
I have to make 2 sequences in two separate columns.
I kown that tmap has a function numeric.resetsequence, but how do I apply it?

Thanks

Re: Numeric sequence based on certain data

Anonymous — Fri, 15 Nov 2013 03:31:33 GMT

Hi,

I have to make 2 sequences in two separate columns.

Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina

Re: Numeric sequence based on certain data

Anonymous — Fri, 15 Nov 2013 16:09:43 GMT

Hi Sabrina:
Right now output is:
-1|37115|-1|FAC-36012013|241.87|
-2|37115|-2|FAC-36012013|196.64|
-3|37115|-3|FAC-36012013|196.64|
-4|37115|-4|FAC-36012013|0.00|
-5|37115|-5|FAC-36012013|0.00|
-6|37115|-6|FAC-36022013|171.72|
-7|37115|-7|FAC-36022013|139.61|
-8|37115|-8|FAC-36022013|139.61|
-9|37115|-9|FAC-36022013|0.00|
-10|37115|-10|FAC-36022013|0.00|
-11|37115|-11|FAC-36032013|124.25|
-12|37115|-12|FAC-36032013|96.27|
-13|37115|-13|FAC-36032013|96.27|
-14|37115|-14|FAC-36032013|4.75|
-15|37115|-15|FAC-36032013|4.75|

1st numeric sequences is based on string: "FAC-36012013"
2nd numeric sequences is based on sub-string: "36012013" (a Fake column) because if I based the numeric sequence on the same row the result will be:
Column 1: 1,3,5,7,9 and so on...and 2nd column will be:2,4,6,8,10 and so on..

Desired output:
-1|37115|-1|FAC-36012013|241.87|
-1|37115|-1|FAC-36012013|196.64|
-1|37115|-1|FAC-36012013|196.64|
-1|37115|-1|FAC-36012013|0.00|
-1|37115|-1|FAC-36012013|0.00|
-2|37115|-2|FAC-36022013|171.72|
-2|37115|-2|FAC-36022013|139.61|
-2|37115|-2|FAC-36022013|139.61|
-2|37115|-2|FAC-36022013|0.00|
-2|37115|-2|FAC-36022013|0.00|
-3|37115|-3|FAC-36032013|124.25|
-3|37115|-3|FAC-36032013|96.27|
-3|37115|-3|FAC-36032013|96.27|
-3|37115|-3|FAC-36032013|4.75|
-3|37115|-3|FAC-36032013|4.75|

Thanks again

Re: Numeric sequence based on certain data

Anonymous — Fri, 29 Nov 2013 11:51:14 GMT

Hello!
Can anyone help with this issue?
Thanks