title: JMeter soap response - data analysis
body: <p>I am doing some data analysis on address data. The data for the analysis is to be generated calling soap web service which returns soap response. 
  In each soap response I am interested only in specific field i.e. 'matchType' in the example shown below. 'matchType' can have multiple occurrences maximum upto 20.
  I have 500 addresses for which I get 500 responses similar to the one shown below. I am using JMeter to fire 500 soap requests to the web service.</p>
  
  <p>Problem</p>
  
  <pre><code>How I can create the final results in CSV file containing 500 records that looks like
  Addressline1, MatchType1, MatchType2 ... MatchType20
  </code></pre>
  
  <p>For above fields
  Addressline1 to get from SOAP request
  MatchType to get from SOAP response</p>
  
  <p>If there is no MatchTypeN it leaves blank.</p>
  
  <p>e.g. CSV file looks like this</p>
  
  <p>10 Main Street, building, street, , , , , , ... , (upto 20th MatchType)
  Park Avenue, building, building, building, ... , (upto 20th MatchType)</p>
  
  <p>SOAP Request</p>
  
  <pre><code>&lt;soapenv:Envelope xmlns:sch="http://website.com/WebService/Schema/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"&gt;
    &lt;soapenv:Body&gt;
      &lt;sch:AddressRequest&gt;
        &lt;AddressRequestDetails&gt;
          &lt;lookupCriteria&gt;
            &lt;houseName/&gt;
            &lt;addressLine1&gt;10 Main Street&lt;/addressLine1&gt;
            &lt;addressLine2&gt;&lt;/addressLine2&gt;
            &lt;addressLine3&gt;&lt;/addressLine3&gt;
            &lt;region/&gt;
            &lt;county&gt;New York&lt;/county&gt;
            &lt;country/&gt;
          &lt;/lookupCriteria&gt;
        &lt;/AddressRequestDetails&gt;
      &lt;/sch:AddressRequest&gt;
    &lt;/soapenv:Body&gt;
  &lt;/soapenv:Envelope&gt;
  </code></pre>
  
  <p>SOAP Response</p>
  
  <pre><code>&lt;soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"&gt;
  &lt;soap:Body&gt;
      &lt;ns2:AddressResponse xmlns:ns2="http://website.com/WebService/Schema/"&gt;
          &lt;AddressResponseDetails&gt;
              &lt;location&gt;
                  &lt;matchType&gt;building&lt;/matchType&gt;
                  &lt;locationCoordinates&gt;
                      &lt;xCoordinate&gt;111111.111&lt;/xCoordinate&gt;
                      &lt;yCoordinate&gt;222222.222&lt;/yCoordinate&gt;
                      &lt;coordinateSystem&gt;ABC&lt;/coordinateSystem&gt;
                  &lt;/locationCoordinates&gt;
              &lt;/location&gt;
              &lt;location&gt;
                  &lt;matchType&gt;street&lt;/matchType&gt;
                  &lt;locationCoordinates&gt;
                      &lt;xCoordinate&gt;333333.333&lt;/xCoordinate&gt;
                      &lt;yCoordinate&gt;444444.444&lt;/yCoordinate&gt;
                      &lt;coordinateSystem&gt;DEF&lt;/coordinateSystem&gt;
                  &lt;/locationCoordinates&gt;
              &lt;/location&gt;
          &lt;/AddressResponseDetails&gt;
      &lt;/ns2:AddressResponse&gt;
  &lt;/soap:Body&gt;
  </code></pre>
  
  <p>    </p>