topic How to generate a sequence number in Talend using Tmap in Talend Studio

How to generate a sequence number in Talend using Tmap

Anonymous — Mon, 29 Jan 2018 06:51:34 GMT

Hello,

I am new to Talend.

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

Regards,

Deepak

Re: How to generate a sequence number in Talend using Tmap

TRF — Mon, 29 Jan 2018 07:01:24 GMT

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.

Re: How to generate a sequence number in Talend using Tmap

Anonymous — Mon, 29 Jan 2018 07:07:37 GMT

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

Re: How to generate a sequence number in Talend using Tmap

Anonymous — Mon, 29 Jan 2018 07:20:55 GMT

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

Re: How to generate a sequence number in Talend using Tmap

TRF — Mon, 29 Jan 2018 07:39:09 GMT

Must be Integer of course

Re: How to generate a sequence number in Talend using Tmap

Anonymous — Mon, 29 Jan 2018 08:00:08 GMT

Thanks it worked

Re: How to generate a sequence number in Talend using Tmap

Sgupta1623918845 — Thu, 17 Jun 2021 08:41:36 GMT

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