We've an XML contains data. We need to extract data from it and move it in to a different XML. Both XMLs are different in structure.
We have Altova and we want to do this job by using it. Any solution on this; which Altova tool will be best for this job and how?
What you're looking for is a XSL Transformation which in itself is again a XML document that describes how to create the new XML from the old XML.
Check out this W3Schools section on learning XSLT for that.
In terms of the Altova tools - you could either use the MapForce data mapper (which sounds like that you're looking for), or alternatively the StyleVision tool to create and maintain the XSLT files. Try MapForce first - sounds like a good fit.
Marc