Hi MHeyd, What database engine do you use? For a supported database, you could try the "Use DB to generate the sequence" option in the Add sequence transform [1]. Another option could be to use an option similar to an auto increment, where your table's primary key uses that sequence to create the next value, but a lot depends on your use case and requirements there.
[1] https://hop.apache.org//manual/latest/pipeline/transforms/addsequence.html Regards, Bart On Tue, Dec 17, 2024 at 1:39 PM <[email protected]> wrote: > Hello Apache Hop Users, > > > > I’m trying to Create data via a ‘Table Output’ transform. > > > > One of the field shall contain a sequence value. The next db sequence > value can be generated like this > > nextval('db."myfield_seq"') > > > > Do you know how to pass this to the ’table output’ transform? > > > > (I have also tried to read first all new sequences but could not combine > a ‘table input’ with an ‘excel input’) > > > > Thank you in advance for your help > > > > >
