title: How to priortize execution of xml tags in txmlMap using talend
body: <p>I am new to Talend and I am facing problems while working with txmlmap.</p>
  
  <p>I have a XML file and I need to insert the data from that XML into SQL Server. I have made connection in Talend to connect to SQL Server, however I am facing some problems while prioritizing the XML tags.</p>
  
  <p>Here is my XML file:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;data&gt;
      &lt;entry name="opertaion-round-title"&gt;
          &lt;valstr&gt;ROUND 1&lt;/valstr&gt;
      &lt;/entry&gt;
      &lt;entry name="site"&gt;
          &lt;valstr&gt;SITE NAME&lt;/valstr&gt;
      &lt;/entry&gt;
      &lt;entry name="plant"&gt;
          &lt;valstr&gt;PLANT NAME&lt;/valstr&gt;
      &lt;/entry&gt;
      &lt;entry name="opertaion-area"&gt;
          &lt;valstr&gt;G AREA&lt;/valstr&gt;
      &lt;/entry&gt;
  &lt;/data&gt;
  </code></pre>
  
  <p>I am using <code>txmlMap</code> to pass data from XML to the database. I have four tables. I need to put the values based on the entry tag (name).</p>
  
  <pre><code>SITES,
  PLANTS,
  OPERATING_AREAS,
  OPERATING_ROUNDS
  </code></pre>
  
  <p>I need to put site value to SITES table, plant value to PLANTS table, operation-area value to OPERATING_AREAS table and operation-round-title to OPERATING_ROUNDS table.</p>
  
  <p>I am successfully getting the values in the table, however I first want to insert site value to SITES table followed by plants value in PLANTS table then OPERATING_AREAS and OPERATING_ROUNDS table.</p>
  
  <p>The problem which I am facing is that whatever value is first present in xml its inserting to that table. i.e in this case its first inserting the values to OPERATING_ROUNDS table because the first tag in the xml is <code>&lt;entry name="opertaion-round-title"&gt;</code>. But I want in the following order</p>
  
  <pre><code>SITES
  PLANTS
  OPERATING_AREAS
  OPERATING_ROUNDS
  </code></pre>
  
  <p>So Is there anyway in which we can set priority of execution of tags in txmlMap so that irrespective of whatever tag comes first It will process the tags based on the priority which we have defined.</p>
  
  <p>Please find attached screen shot of </p>
  
  <p><a href="https://i.stack.imgur.com/VdwfV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VdwfV.png" alt="design of components"></a> </p>
  
  <p>and</p>
  
  <p><a href="https://i.stack.imgur.com/9sHau.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9sHau.png" alt="txmlMap configuration"></a></p>