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]<mailto:[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
