Thanks! I think I tried a variation of this too which didn't work. But it didn't work at the time because the data was flawed in general. ...

I guess sometimes the simplest sanity checks are the best. I re-imported the XML file and now it is working as expected. What's odd is that I swear...

Thanks but yes I had just caught that after posting. That was from a previous unsuccessful attempt at something. I updated my post minutes ago. It is...