this is my xml file (input file). what is the xsl file that I need to write in order to get the output that is written below? (please help)

<root>
    <imports/>
    <entities>
        <entity key="common">
            <launching>
                <parameters-activity>
                    <values>
                        <value parameter-name="launched-product-code" parameter-value="IS"/>
                        <value parameter-name="apptier-id" parameter-value="!~apptier_id!~"/>
                        <value parameter-name="timeFrame" parameter-value="!~timeframe!~"/>
                        <value parameter-name="sort" parameter-value="OO_TT"/>
                        <value parameter-name="display" parameter-value="overview"/>
                    </values>
                </parameters-activity>
            </launching>
        </entity>
        <entity key="Instance">
            <launching>
                <parameters>
                    <values>
                        <value parameter-name="launched-product-code" parameter-value="IS"/>
                        <value parameter-name="apptier-id" parameter-value="!~apptier_id!~"/>
                        <value parameter-name="timeFrame" parameter-value="!~timeframe!~"/>
                        <value parameter-name="sort" parameter-value="OO_TT"/>
                        <value parameter-name="display" parameter-value="overview"/>
                        <value parameter-name="drilldown" parameter-value="&lt;drilldowns&gt;&lt;drilldown field=&quot;instance&quot; value=&quot;!~instance!~&quot; id=&quot;instance_id&quot; id_value=&quot;!~instance_id!~&quot;/&gt;&lt;/drilldowns&gt;"/>
                        <value parameter-name="entityType" parameter-value="program"/>
                    </values>
                </parameters>
            </launching>
        </entity>
        <entity key="Client IP">
            <launching>
                <parameters>
                    <values>
                        <value parameter-name="launched-product-code" parameter-value="IS"/>
                        <value parameter-name="apptier-id" parameter-value="!~apptier_id!~"/>
                        <value parameter-name="sort" parameter-value="OO_TT"/>
                        <value parameter-name="display" parameter-value="overview"/>
                        <value parameter-name="drilldown" parameter-value="&lt;drilldowns&gt;&lt;drilldown field=&quot;instance&quot; value=&quot;!~instance!~&quot; id=&quot;instance_id&quot; id_value=&quot;!~instance_id!~&quot;/&gt;
                        &lt;drilldown field=&quot;client_ip&quot; value=&quot;!~entity!~&quot; id=&quot;client_ip_id&quot; id_value=&quot;!~entity_id!~&quot;/&gt;&lt;/drilldowns&gt;"/>
                        <value parameter-name="entityType" parameter-value="program"/>
                    </values>
                </parameters>
            </launching>
        </entity>
    </entities>
</root>

to get this out put

<root>
    <imports/>
    <entities>
        <entity key="common">
            <launching>
                <parameters-activity>
                    <values>
                        <value parameter-name="launched-product-code" parameter-value="IS"/>
                        <value parameter-name="apptier-id" parameter-value="!~apptier_id!~"/>
                        <value parameter-name="timeFrame" parameter-value="!~timeframe!~"/>
                        <value parameter-name="sort" parameter-value="OO_TT"/>
                        <value parameter-name="display" parameter-value="overview"/>
                    </values>
                </parameters-activity>
            </launching>
        </entity>
        <entity key="Instance">
            <launching>
                <parameters>
                    <values>
                        <value parameter-name="launched-product-code" parameter-value="IS"/>
                        <value parameter-name="apptier-id" parameter-value="!~apptier_id!~"/>
                        <value parameter-name="timeFrame" parameter-value="!~timeframe!~"/>
                        <value parameter-name="sort" parameter-value="OO_TT"/>
                        <value parameter-name="display" parameter-value="overview"/>
                        <value parameter-name="drilldown" parameter-value="&lt;drilldowns&gt;&lt;drilldown field=&quot;instance&quot; value=&quot;!~instance!~&quot; id=&quot;instance_id&quot; id_value=&quot;!~instance_id!~&quot;/&gt;&lt;/drilldowns&gt;"/>
                        <value parameter-name="entityType" parameter-value="program"/>
                    </values>
                </parameters>
            </launching>
        </entity>
        <entity key="Client IP">
            <launching>
                <parameters>
                    <values>
                        <value parameter-name="launched-product-code" parameter-value="IS"/>
                        <value parameter-name="timeFrame" parameter-value="!~timeframe!~"/>
                        <value parameter-name="sort" parameter-value="OO_TT"/>
                        <value parameter-name="compare" parameter-value="overview"/>
                        <value parameter-name="context" parameter-value="&lt;navigation-name&gt;&lt;predicate apptierId=&quot;!~apptier_id!~&quot; key=&quot;instance&quot;&gt;&lt;value&gt;!~instanc e!~&lt;/value&gt;&lt;/predicate&gt;&lt;/navigation-name&gt;&lt;navigation-id&gt;&lt;predicate apptierId=&quot;!~apptier_id!~&quot; key=&quot;instance_id&quot;&gt;&lt;value&gt;!~inst ance_id!~&lt;/value&gt;&lt;/predicate&gt;&lt;/navigation-id&gt;&lt;navigation-tooltip&gt;&lt;predicate key=&quot;client_ip&quot; display=&quot;TU-client_ip&quot; &gt;&lt;value&gt;&lt;![CDATA[!~entity!~]]&gt;&lt;/value&gt;&lt;/predicate&gt;&lt;/navigation-tooltip&gt;"/>
                        <value parameter-name="associate" parameter-value="program"/>
                    </values>
                </parameters>
            </launching>
        </entity>
    </entities>
</root>

thank you

This is like a "spot the differences" competition in a child's picture-book. You need to explain the rules that drive the transformation. Why is the drilldown property omitted when it's part of "Client IP" but not when it's part of "Instance", for example? Unless you know the rules, I could just write a stylesheet that generates the output regardless what the input is.

You also need to explain where you are having difficulty with your XSLT coding. It doesn't look like a difficult problem, so to help you, I need to understand which part of the language you are having difficulty with.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference