topic Re: Unable to generate Sequence number in Talend Data mapper in Talend Studio

Unable to generate Sequence number in Talend Data mapper

Anonymous — Wed, 30 Mar 2016 11:19:08 GMT

I need to generate a sequence number for EDI format message in Talend. I tried to use " GetSequenceFromLocalFile " function but it was not allowing to set the file path property. In Talend Data Integration there is routine function called " Number.sequence("s1",1,1) ". Can I used the same in Data mapper? Is there any other way to generate sequence number? Can we generate sequence without using database connection?

Re: Unable to generate Sequence number in Talend Data mapper

Anonymous — Fri, 08 Apr 2016 10:09:23 GMT

Hi,

You can use built-in function Numeric.sequence("s1",1,1) to generate a sequence number in tMap component.

Best regards

Sabrina

Re: Unable to generate Sequence number in Talend Data mapper

acs0508 — Mon, 08 Jul 2019 17:10:44 GMT

Hello,

But is there any way i can add the Numeric value in TDM itself, instead of adding additional tMap Component in my Data Integration job???

Re: Unable to generate Sequence number in Talend Data mapper

jeoste — Thu, 16 Jul 2020 14:11:29 GMT

Hello,

Is there a way to do it natively inside Data Mapper ? Or should we just create a custom java routine and call it inside Data Mapper instead ?

If someone knows how to do it, feel free to share your tip 🙂