topic Re: [resolved] Sequence Generation in Talend Studio

[resolved] Sequence Generation

Anonymous — Wed, 13 Mar 2013 04:54:51 GMT

Hi All,
My source is as below ( refer to screenshot which has nulls under C1 column).
My expected output is as below (refer to screenshot which has no nulls).

Kindly assist.
Thanks,
Saty.

Re: [resolved] Sequence Generation

Anonymous — Wed, 13 Mar 2013 05:55:43 GMT

Hi,
Could you show us your screenshot of your work flow? Which component do you use to get such actual result? And what about your original data? More information will help us to give you a precise answer.
Best regards
Sabrina

Re: [resolved] Sequence Generation

Anonymous — Wed, 13 Mar 2013 08:31:57 GMT

Hi Sabrina,
I have the source as in the screenshot ( refer to screenshot which has nulls under C1 column).
And I didn't get the output. I'm trying to do it in MySQL.. But I want to do it in Talend job itself.
Kindly assist.
Thanks,
Saty.

Re: [resolved] Sequence Generation

Anonymous — Wed, 13 Mar 2013 09:33:19 GMT

Hi,
From your expected result screenshot, I have seen the sequence is "2,3,4,5,2,3,4,2,3,4,5,6". Is any rule in it?
You can use component tMap and set a local variable for sequence.
See my screenshots
The expression is:

Numeric.sequence("s1",2,1)

Best regards
Sabrina

Re: [resolved] Sequence Generation

Anonymous — Wed, 13 Mar 2013 12:00:42 GMT

Hi Sabrina,

The expression is:
Numeric.sequence("s1",2,1)

Thanks for the reply. I'm aware of the above expression to generate sequence. But my requirement is as below.

I have 3 unique values under C2 column. If a value under C2 repeats for 4 times then C1 should start from 2,3,4,5.
If another value under C2 repeats for 9 times then C1 should start from 2,3,4,5,6,7,8,9,10 etc,.
I hope u have understood this.
Thnx,
Saty.

Re: [resolved] Sequence Generation

janhess — Wed, 13 Mar 2013 13:32:43 GMT

you have to base your sequence on the value in C2.
Numeric.sequence(inputrow.c2,2,1)

Re: [resolved] Sequence Generation

Anonymous — Thu, 14 Mar 2013 03:56:51 GMT

Hi id4dsc,

Numeric.sequence(inputrow.c2,2,1)

janhess's suggestion is pretty good. I upload my screenshots to let you understand it more clearly.
Best regards
Sabrina

Re: [resolved] Sequence Generation

Anonymous — Thu, 14 Mar 2013 04:48:21 GMT

Numeric.sequence(inputrow.c2,2,1)

Hi Janhess,
Thanks. It is working.
Hi Sabrina,
I have used above expression in my job and got the output. Thanks for reply.

Thanks,
Saty.

Re: [resolved] Sequence Generation

Anonymous — Thu, 03 Oct 2013 01:54:14 GMT

Hi,
Please let me know how achieve not equal to condition in Talend?
Ex: Have Table 1 and Table 2 with fileds as field 1 from table 1 and filed 2 from table 2. Now i want to join these tables and check whether table 1.filed 1<> table 2.filed 2.

Please let me know how I can achieve this..

Re: [resolved] Sequence Generation

Anonymous — Tue, 08 Oct 2013 06:34:43 GMT

Hi srk08536,
Please open a new topic for your issue.

Ex: Have Table 1 and Table 2 with fileds as field 1 from table 1 and filed 2 from table 2. Now i want to join these tables and check whether table 1.filed 1<> table 2.filed 2.

Did you see the component tMap. You can join two table and set a condition in it.
Best regards
Sabrina