title: Parsing through XML and dump values into Excel using UIPATH
body: <p>I would like to dump data for only BMW cars to excel. I do have thousands of XML files and a number of entries will vary (in this case 3, it could from 0 to 5). </p>
  
  <p>Considering this scenario, I have to increment counter or transaction item in UIPATH. But to start with I would like to dump data into excel for this XML file and I am expecting output given in the attached image</p>
  
  <pre><code>    &lt;country&gt;
                  &lt;state&gt;Texas&lt;/state&gt;
                      &lt;cars&gt;        
                                   &lt;brand&gt;BMW&lt;/brand&gt;
                                   &lt;model&gt;X1&lt;/model&gt;
                                   &lt;unit&gt;210000&lt;/unit&gt;        
                      &lt;/cars&gt;
                      &lt;cars&gt;        
                                  &lt;brand&gt;BMW&lt;/brand&gt;
                                  &lt;model&gt;X6&lt;/model&gt;
                                  &lt;unit&gt;210000&lt;/unit&gt;     
                      &lt;/cars&gt;
                      &lt;cars&gt;        
                                  &lt;brand&gt;BMW&lt;/brand&gt;
                                  &lt;model&gt;X7&lt;/model&gt;
                                   &lt;unit&gt;210000&lt;/unit&gt;        
                      &lt;/cars&gt;
                      &lt;cars&gt;        
                                   &lt;brand&gt;Ford&lt;/brand&gt;
                                   &lt;model&gt;mustang&lt;/model&gt;
                                   &lt;unit&gt;319000&lt;/unit&gt;        
                      &lt;/cars&gt;
                      &lt;cars&gt;        
                                   &lt;brand&gt;Volvo&lt;/brand&gt;
                                  &lt;model&gt;XC90&lt;/model&gt;
                                   &lt;unit&gt;91100&lt;/unit&gt;     
                      &lt;/cars&gt; 
      &lt;/country&gt;
  </code></pre>
  
  <p>**Output - **</p>
  
  <p><a href="https://i.stack.imgur.com/6NciZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6NciZ.png" alt="enter image description here"></a></p>