<div>
Also I have code in groovy which only gets the top manager or the manager level 5. but I would need all the managers displayed for a corresponding user ID as per my original requirement. Please suggest or provide a sample code for either XSLT or Groovy to achive the rek. The code in Groovy <a href="https://filedb.experts-exchange.com/incoming/2021/08_w35/1570465/InitializeHashMap.groovy" rel="ugc">InitializeHashMap.groovy</a> <a href="https://filedb.experts-exchange.com/incoming/2021/08_w35/1570466/PopulateHashMap.groovy" rel="ugc">PopulateHashMap.groovy</a> <a href="https://filedb.experts-exchange.com/incoming/2021/08_w35/1570467/Main.groovy" rel="ugc">Main.groovy</a> Jar required is <a href="https://filedb.experts-exchange.com/incoming/2021/08_w35/1570471/cloud.integration.script.apis-2.7.1.7z" rel="ugc">cloud.integration.script.apis-2.7.1.7z</a> The core logic is the following: <pre><code class="code-10 nolinks" id="code-20-43330563-1">def transformedXml = builder.bind {
&nbsp; &nbsp; &nbsp; &nbsp;mkp.xmlDeclaration() 
&nbsp; &nbsp; 
&nbsp; &nbsp; EmpJob {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; def EmpJob1 = parsedXml.'*'.findAll{ it.name() == 'EmpJob'} 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EmpJob1.each { EmpJobs -&gt;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EmpJob {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;userId (EmpJobs.userId.text())
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mgr= EmpJobs.managerId.text();
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; key=EmpJobs.userId.text();
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; def value= null;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; def int max=0;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while( value!='1111111') {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; value = getdata.get(key);
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; max++;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (value=='1111111')
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(value!=null) {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; key = value;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; key= null;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(max&gt;5)
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;managerLvl1(key)
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;}
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }
</code></pre>But the output of the above just give the top most manager as shown below : <pre><code class="code-10 nolinks" id="code-20-43330563-2">&lt;EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;1222222&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;4444444&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;42479&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;5555555&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;3333333&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;885247&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;2222222&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;885311&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;885325&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&lt;EmpJob&gt;
</code></pre>
</div>

Main.groovy

cloud.integration.script.apis-2.7.1.7z

InitializeHashMap.groovy

PopulateHashMap.groovy

kalyangkm

<div>
However, this would give you a result like this <pre><code class="code-10 nolinks" id="code-20-43330577-1">&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;EmpJob&gt;
&nbsp; &nbsp;&lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;1222222&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;2222222&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;3333333&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;4444444&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;5555555&lt;/managerId&gt;
&nbsp; &nbsp;&lt;/EmpJob&gt;
&nbsp; &nbsp;&lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;4444444&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;2222222&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;3333333&lt;/managerId&gt;
&nbsp; &nbsp;&lt;/EmpJob&gt;
&nbsp; &nbsp;&lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;42479&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp;&lt;/EmpJob&gt;
&nbsp; &nbsp;&lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;5555555&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;2222222&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;3333333&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;4444444&lt;/managerId&gt;
&nbsp; &nbsp;&lt;/EmpJob&gt;
&nbsp; &nbsp;&lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;3333333&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;2222222&lt;/managerId&gt;
&nbsp; &nbsp;&lt;/EmpJob&gt;
&nbsp; &nbsp;&lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;885247&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp;&lt;/EmpJob&gt;
&nbsp; &nbsp;&lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;2222222&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp;&lt;/EmpJob&gt;
&nbsp; &nbsp;&lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;885311&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp;&lt;/EmpJob&gt;
&nbsp; &nbsp;&lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;885325&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;2222222&lt;/managerId&gt;
&nbsp; &nbsp;&lt;/EmpJob&gt;
&lt;/EmpJob&gt;


</code></pre>You can then run a second XSLT over that result to number the manager levels. Let me know if that is acceptable The second XSLT would be really really easy, let me know if you can't do that one, I will If you need it in one XSLT, you can have a recursive function counting the levels up and start numbering accordingly from the ground up... interesting challenge
</div>

<div>
Hi Geert, This is really Good. Can you also provide the solution for first approach using the second XSLT. Do you provide mentoring service? I would like get started and get familiarized with all the basic concepts and functions. If so please let me know I can reach you offline. Regards Kalyan.
</div>

<div>
<div class="content wysiwyg-content fr-view">
Hi Folks, I have a hierarchy problem where in the manager hierarchy needs to be shown for an employee upto a level of 5 or the top level/CEO. &nbsp;So I have user ID and manager ID as Key and Value pairs respectively&nbsp;From the following XML input which has the User ID and Manger ID I would need the User ID and the corresponding mangers upto to the top most level or the 5 level and the top most manager/CEO user ID is "1111111".&nbsp; Input XML<pre><code class="code-10 nolinks" id="code-10-29223044-1">&lt;EmpJob&gt; &nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;5555555&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;1222222&lt;/userId&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;3333333&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;4444444&lt;/userId&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;42479&lt;/userId&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;4444444&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;5555555&lt;/userId&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;2222222&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;3333333&lt;/userId&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;885247&lt;/userId&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;2222222&lt;/userId&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;1111111&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;885311&lt;/userId&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;managerId&gt;2222222&lt;/managerId&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;885325&lt;/userId&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&lt;EmpJob&gt;
</code></pre>Desired output XML<pre><code class="code-10 nolinks" id="code-10-29223044-2">&lt;EmpJob&gt; &nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;1222222&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp;&nbsp; &lt;mangerLvl2&gt;2222222&lt;/mangerLvl2&gt;
&nbsp; &nbsp;&nbsp; &lt;mangerLvl3&gt;3333333&lt;/mangerLvl3&gt;
&nbsp; &nbsp;&nbsp; &lt;mangerLvl4&gt;4444444&lt;/mangerLvl4&gt;
&nbsp; &nbsp;&nbsp; &lt;mangerLvl5&gt;5555555&lt;/mangerLvl5&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;4444444&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp;&nbsp; &lt;mangerLvl2&gt;2222222&lt;/mangerLvl2&gt;
&nbsp; &nbsp;&nbsp; &lt;mangerLvl3&gt;3333333&lt;/mangerLvl3&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;42479&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;5555555&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp;&nbsp; &lt;mangerLvl2&gt;2222222&lt;/mangerLvl2&gt;
&nbsp; &nbsp;&nbsp; &lt;mangerLvl3&gt;3333333&lt;/mangerLvl3&gt;
&nbsp; &nbsp;&nbsp; &lt;mangerLvl4&gt;4444444&lt;/mangerLvl4&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;3333333&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp;&nbsp; &lt;mangerLvl2&gt;2222222&lt;/mangerLvl2&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;885247&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;2222222&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;885311&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&nbsp; &nbsp; &lt;EmpJob&gt;
&nbsp; &nbsp; &nbsp; &lt;userId&gt;885325&lt;/userId&gt;
&nbsp; &nbsp; &nbsp; &lt;mangerLvl1&gt;1111111&lt;/mangerLvl1&gt;
&nbsp; &nbsp;&nbsp; &lt;mangerLvl2&gt;2222222&lt;/mangerLvl2&gt;
&nbsp; &nbsp; &lt;/EmpJob&gt;
&lt;EmpJob&gt;
</code></pre>
</div>
</div>

Hi Folks,
I have a hierarchy problem where in the manager hierarchy needs to be shown for an employee upto a level of 5 or the top level/CEO.  So I have user ID and manager ID as Key and Value pairs respectively 
From the following XML input which has the User ID and Manger ID I would need the User ID and the corresponding mangers upto to the top most level or the 5 level and the top most manager/CEO user ID is "1111111". 
Input XML
<EmpJob>
    <EmpJob>
      <managerId>5555555</managerId>
      <userId>1222222</userId>
    </EmpJob>
    <EmpJob>
      <managerId>3333333</managerId>
      <userId>4444444</userId>
    </EmpJob>
    <EmpJob>
      <managerId>1111111</managerId>
      <userId>42479</userId>
    </EmpJob>
    <EmpJob>
      <managerId>4444444</managerId>
      <userId>5555555</userId>
    </EmpJob>
    <EmpJob>
      <managerId>2222222</managerId>
      <userId>3333333</userId>
    </EmpJob>
    <EmpJob>
      <managerId>1111111</managerId>
      <userId>885247</userId>
    </EmpJob>
    <EmpJob>
      <managerId>1111111</managerId>
      <userId>2222222</userId>
    </EmpJob>
    <EmpJob>
      <managerId>1111111</managerId>
      <userId>885311</userId>
    </EmpJob>
    <EmpJob>
      <managerId>2222222</managerId>
      <userId>885325</userId>
    </EmpJob>
<EmpJob>
Desired output XML
<EmpJob>
    <EmpJob>
      <userId>1222222</userId>
      <mangerLvl1>1111111</mangerLvl1>
     <mangerLvl2>2222222</mangerLvl2>
     <mangerLvl3>3333333</mangerLvl3>
     <mangerLvl4>4444444</mangerLvl4>
     <mangerLvl5>5555555</mangerLvl5>
    </EmpJob>
    <EmpJob>
      <userId>4444444</userId>
      <mangerLvl1>1111111</mangerLvl1>
     <mangerLvl2>2222222</mangerLvl2>
     <mangerLvl3>3333333</mangerLvl3>
    </EmpJob>
    <EmpJob>
      <userId>42479</userId>
      <mangerLvl1>1111111</mangerLvl1>
    </EmpJob>
    <EmpJob>
      <userId>5555555</userId>
      <mangerLvl1>1111111</mangerLvl1>
     <mangerLvl2>2222222</mangerLvl2>
     <mangerLvl3>3333333</mangerLvl3>
     <mangerLvl4>4444444</mangerLvl4>
    </EmpJob>
    <EmpJob>
      <userId>3333333</userId>
      <mangerLvl1>1111111</mangerLvl1>
     <mangerLvl2>2222222</mangerLvl2>
    </EmpJob>
    <EmpJob>
      <userId>885247</userId>
      <mangerLvl1>1111111</mangerLvl1>
    </EmpJob>
    <EmpJob>
      <userId>2222222</userId>
      <mangerLvl1>1111111</mangerLvl1>
    </EmpJob>
    <EmpJob>
      <userId>885311</userId>
      <mangerLvl1>1111111</mangerLvl1>
    </EmpJob>
    <EmpJob>
      <userId>885325</userId>
      <mangerLvl1>1111111</mangerLvl1>
     <mangerLvl2>2222222</mangerLvl2>
    </EmpJob>
<EmpJob>

Would need a solution for this problem either in XSLT or Groovy script

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).