glad you got that sorted out! On Tue, Dec 17, 2024 at 2:07 PM <[email protected]> wrote:
> Thank you Bart, > > > > I’ve just found that I could actually also use the ‘Add Sequence’ > transform > > > > Silly Me ! > > > > Thanks for the help > > > > > > *From:* Bart Maertens <[email protected]> > *Sent:* Tuesday, 17 December 2024 13:46 > *To:* [email protected] > *Subject:* Re: How to create data with a seq_next val > > > > 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 > <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 > > > > > >
