[HOP-4519] Why Xml join supports only one target stream row.

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Not A Bug
• Fix Version/s: Not applicable
• Assignee: Unassigned
• Reporter: suriya
• Created: 28/Oct/22 01:45
• Updated: 28/Oct/22 12:26
• Resolved: 28/Oct/22 12:26

Description

I found below description from hop website for xml join: - 

The target stream must have only one row, since it represents a XML document.

But myy requirement is to display multiple rows in target stream. Why this restriction there in existing xml join? Is there any particular reason to have only one row as output?

Below is the requirement or expectation for my project: -

the below sample xml i found under the integration test folder.

Here i have modified the xml file and inserted one more records to it. now we have 2 records in xl sheet and add xml also produces 2 row output for the given xl. please refer below screenshot.

but after xml join we are able to see only one record that is first record from xl sheet. Why we are not supporting the other one. seems we fetch first record alone. Is there any specific reason behind this or can we modify the code to support multiple rows?

Please suggest!