How to generate a sequence number in Talend using Tmap

[Anonymous]

Hello,

I am new to Talend.

I want to know the process to generate sequence number. Can anyone help me plz.

Regards,

Deepak

[TRF]

Hi,
For example, on the output side of a tMap add the desired field with the expression:
Numeric.sequence("name", 0, 1)
to create a sequence called "name" starting with 0 incremented by 1.

[Anonymous]

Thanks for the reply.

I followed the below steps.

1. Created a new field called SEQ in the output side.

2. Added the expression as Numeric.Sequence("S1",1,1)

In tMap it is giving the error. Will that be issue with datatype? 

Currently I have created a new field SEQ as String type. 

Regards,
Deepak

[Anonymous]

And also I have created a field called SEQ in MySQL database as well. 

[TRF]

Must be Integer of course

[Anonymous]

Thanks it worked

[Sgupta1623918845]

If your program will be done then let me know because my side there is lot of issues occur