Skip to Content
0
Former Member
May 20, 2016 at 08:15 PM

How to combine 2 unrelated XML tables

23 Views

Our phone system creates 2 XML reports with no common field: 1) Queue Phone report and 2) Member Phone report.

1) Queue Phone report shows data pertaining to each Queue (or group) of phones:

Example: Front Desk Queue answered 50 calls, Back Desk Queue answered 20 calls, Overflow Queue answered 10 calls

2) Member Phone report shows data for each Member of the Queue (or Group).

Example: Mary answered 10 calls (she is part of Front Desk and Overflow Queue), Jane answered 5 calls (she is part of Back Desk Queue)


I need to combine these 2 XML tables, so I can see how many calls "Mary" takes when she is in the "Front Desk" group compared to when she is in the "Overflow" group.

How do I do that?

Thanks for any help.