If i’m understanding the question correctly, then you could just read in the JSON of XML files with the JSON and XML Reader Nodes, convert to a table, and then join the data.
When you use the XML Reader you have the option to specify an XPATH Query or filter. When you use this each matching node in the xml will be read as a single data cell in KNIME and outputted as a table for your manipulation needs.