How to Repeate Specific XML Tags/Values in a Template
I need help repeating a specific value in the XML output several times. Is there some sort of copy function that would be useful? The problem I am running into is that the value I need to repeat is outside of the node that contains the data for the table I am creating. The node for the data is nested in the node that has the repeating value.
I am just learning XML, so hopefully that makes sense.
As a simple example for the data below, I'm trying to create a table that lists each customer with a column that displays the customer number and the sales rep responsible for that customer.
-<LIST_SALESREP>
<SALESREP>JOE B</SALESREP>
-<LIST_CUSTOMER>
<CUSTOMER>
<NAME>ACME 1</NAME>
<NUMBER>45678</NUMBER>
</CUSTOMER>
<CUSTOMER>
<NAME>ACME 2</NAME>
<NUMBER>98765</NUMBER>
<CUSTOMER>
-</LIST_CUSTOMER>
<SALESREP>ANN M</SALESREP>
-<LIST_CUSTOMER>
<CUSTOMER>
<NAME>DEALER A</NAME>
<NUMBER>56754</NUMBER>
</CUSTOMER>
<CUSTOMER>
<NAME>DEALER B</NAME>
<NUMBER>23564</NUMBER>
<CUSTOMER>
-</LIST_CUSTOMER>
-</LIST_SALESREP>
Any help or suggestions is greatly appreciated. Thanks!