Merge XML files of similar structure

[HenpetsGordres1]

Hi,

I would like to merge two xml files with a similar structure i.e. similar root and child, but differing subchild/body.

e.g. File 1 appears like this:

File 2 appears like this:

header, entries & entry are similar across both files, I want to merge the body (1,2,3,4, 5, 6) so that Output (File 3), appears like this:

I have also included my attempt (MergeXML), I can't figure out how to use the count in 1 to remove those lines. But there are probably better ways to approach the issue.

Many thanks

[DavidP · Accepted solution]

I couldn't load your input files as XML - something's not right with the structure.

Instead, I loaded each file as CSV with delimiter set to \0 and unchecked 1st row contains field names and tried another method to merge them, which is a bit of a hack.

See below and workflow attached.