i have a set of xml data from a database, i want to transform these data into a form that would conform to the target data. in the sense that the elements node would change and the text nodes will also be rearranged something like
source
<?xml version="1.0" encoding="UTF-8"?>
<XMLCreators>
<row>
<RateNumber>1</RateNumber>
<RateLetter>Null</RateLetter>
<AssessmentStreet>Abesinia Passage</AssessmentStreet>
<RateAccomDesc>Dwelling (Part Of)</RateAccomDesc>
</row>
</XMLCreators>
to
target
<?xml version="1.0" encoding="UTF-8"?>
<XMLCreators>
<row>
<locatorDesignator>dwelling (part of) </locatorDesignator>
<locatorName>Null</locatorName>
<locator>1</locator>
<thoroughfare>Abesinia Passage</thoroughfare>
<addressArea>Null</addressArea>
</row>
<XMLCreators>
pls if u could help in anyway or direct me to any tutorials on how to do this. thank you