Hi Suriya, The XML join transform is a little different from other join transforms in the sense that it generates an XML document by merging elements. As such, you'll need to specify one row to merge into, but multiple rows can be merged into that row/element. If you need to generate multiple XML documents, there are various options to create loops, using a pipeline executor transform [2] or repeat action [3].
You can have a look at the XML join integration test [1] as an example. We'll use your ticket as an opportunity to add this or a similar pipeline to the samples project. Regards, Bart [1] https://github.com/apache/hop/blob/master/integration-tests/xml/0001-xml-join-test.hpl [2] https://hop.apache.org/manual/latest/pipeline/transforms/pipelineexecutor.html [3] https://hop.apache.org/manual/latest/workflow/actions/repeat.html On Fri, Oct 28, 2022 at 7:39 AM suriya m <[email protected]> wrote: > Hi All, > > Please have a look at below jirs issue. > [HOP-4519] Why Xml join supports only one target stream row. - ASF JIRA > (apache.org) <https://issues.apache.org/jira/browse/HOP-4519?filter=-2> >
