title: What would be the correct XPath to obtain counterparty with same tag name?
body: <p>I am trying to figure out what the correct XPath would be to obtain information from this XML doc.</p>
  <pre><code>&lt;relationships&gt;
      &lt;relationship&gt;
          &lt;person&gt;
              &lt;name&gt;Jane Doe&lt;/name&gt;
              &lt;role&gt;Customer&lt;/role&gt;
          &lt;/person&gt;
          &lt;person&gt;
              &lt;name&gt;John Doe&lt;/name&gt;
              &lt;role&gt;Vendor&lt;/role&gt;
          &lt;/person&gt;
      &lt;/relationship&gt;
  &lt;/relationships&gt;
  </code></pre>
  <p>What I would like to obtain (I'm using PDI), is a table that sort of looks like this.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Person</th>
  <th>Role</th>
  <th>Other Person</th>
  <th>Other Person Role</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Jane Doe</td>
  <td>Customer</td>
  <td>John Doe</td>
  <td>Vendor</td>
  </tr>
  <tr>
  <td>John Doe</td>
  <td>Vendor</td>
  <td>Jane Doe</td>
  <td>Customer</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Seemingly, two rows for every relationship that exists. But because tags share the same name, I don't know how to add the counterparty to the row.</p>
  <p>Thank you in advance!</p>