Unable to generate Sequence number in Talend Data mapper

One Star

Unable to generate Sequence number in Talend Data mapper

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?
Highlighted
Moderator

Re: Unable to generate Sequence number in Talend Data mapper

 


Hi,


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


Best regards


Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads