akamathb 0 Newbie Poster

Hi,
need help in xslt usage in VERSION 1.0 ... i have requirement to convert a xml to anaother xml using xslt:

For each property != empty condition exists
for property==empty take the previous condition and update the value section only
please help...

input xml is :-
<data jsxid="jsxroot">
<record jsxid="100" slno="1" property="DISTRIBUTION" operator="=" value="UNITED KINGDOM"/>
<record jsxid="101" property="BRAND OWNER" operator="Contains" value="HOOK" />
<record jsxid="102" property="" operator="" value="500ML" />

<record jsxid="1100" slno="2" property="DISTRIBUTION1" operator="=" value="JAPAN"/>
<record jsxid="1101" property="BRAND OWNER1" operator="Contains" value="HOOK1" />
<record jsxid="1102" property="" operator="" value="300ML" />
</data>

i need the o/p as:-
<defaultQuery>
<subQuery slno=1>
<condition>
<property>DISTRIBUTION</property>
<operator>=</operator>
<values>
<value>UNITED KINGDOM</value>
</values>
</condition>
<condition>
<property>BRAND OWNER</property>
<operator>contains</operator>
<values>
<value>HOOK</value>
<value>500ml</value>
</values>
</condition>
</subQuery>
<subQuery slno=2>
<condition>
<property>DISTRIBUTION1</property>
<operator>=</operator>
<values>
<value>JAPAN</value>
</values>
</condition>
<condition>
<property>BRAND OWNER1</property>
<operator>contains</operator>
<values>
<value>HOOK1</value>
<value>300ml</value>
</values>
</condition>
</subQuery>
</defaultQuery>