Need to pass a value in output XML based on a tag value in input XML using XSLT

Lipsita · December 2nd, 2015, 11:18 AM

Input XML:
<?xml version="1.0" encoding="UTF-8"?>
<DATA>
<RECORDS>
<Group>
<Name>12345</Name>
<Grp>MANAGER</Grp>
<FName>Alex</FName>
<LName>Johnson</LName>
<String1>abcd</String1>
</Group>
<Group>
<Name>67891</Name>
<Grp>PROJECT MANAGER</Grp>
<FName>JAMES</FName>
<LName>HARPER</LName>
<String1></String1>
</Group>
</RECORDS>
</DATA>

Requirement:

In output XML

If String1 has a value then Type tag should have value as "axbx" and if String1 is blank then Type tag should have value as "dydy"

<?xml version="1.0" encoding="UTF-8"?>
<DATA>
<RECORDS>
<Group>
<Name>12345</Name>
<Grp>MANAGER</Grp>
<FName>Alex</FName>
<LName>Johnson</LName>
<Type>axbx</Type>
</Group>
<Group>
<Name>67891</Name>
<Grp>PROJECT MANAGER</Grp>
<FName>JAMES</FName>
<LName>HARPER</LName>
<Type>dydy</Type>
</Group>
</RECORDS>
</DATA>

I just need help with the transformation of the Type tag in output XML based on value in String1 in input XML. Please suggest.

mhkay · December 2nd, 2015, 01:02 PM

This seems pretty basic.

...If String1 has a value then Type tag should have value as "axbx" and if String1 is blank then Type tag should have value as "dydy"

Code:

<xsl:template match="String1[. != '']">
  <Type>axbx</Type>
</xsl:template>

<xsl:template match="String1[. = '']">
  <Type>dydy</Type>
</xsl:template>