Unable to generate Sequence number in Talend Data mapper

[Anonymous]

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?

[Anonymous]

Hi,

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

Best regards

Sabrina

[acs0508]

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

[jeoste]

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 🙂