Hi Maria, By default when merging streams the layout should be the same on both sides. Alternatively when merging 2 streams with different lay-outs you can use the stream schema merge transform https://hop.apache.org//manual/latest/pipeline/transforms/streamschemamerge.html
This transform will make sure the result is valid. Kr, Hans On Thu, 26 Jun 2025 at 07:39, Maria Lim <marialy...@gmail.com> wrote: > Hi Apache HOP Support Team, > > I’m currently exploring the migration of ETLs from PDI to Apache HOP. > > While testing a pipeline, I encountered a failure at the "Select > values" transform following the merging of two streams. The error > indicates that a field with the suffix "_1" could not be found—this > corresponds to a duplicated fieldname resulting from the merge. > > The issue appears to align with the one reported on GitHub last year: > https://github.com/apache/hop/issues/3849 > > After reviewing that discussion, I attempted to rebuild the pipeline > entirely in HOP, hoping for a different result. Unfortunately, the > issue persists. > > Aside from known workarounds like renaming fields prior to the merge > to avoid duplication, is there a more direct or quicker fix available > for this behaviour? > > Appreciate your insights and support. > > Kind regards, > Maria >
