XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
satish kumarSubject: Mapping problem please help me
Author: satish kumar
Date: 08 Jun 2007 04:26 AM
I am having two XML structures those are
Source Struck:
<?xml version="1.0" encoding="UTF-8"?>

<ns0:EmpFileinfo xmlns:ns0="http://ehro.eds.com/LAB_TEST/EmpCommunication">
<Row>
<Dno>10t</Dno>
<Designation>Manager</Designation>
<Department>Accounts</Department>
</Row>
</ns0:EmpFileinfo>

Receiver Struc:
<?xml version="1.0" encoding="UTF-8"?>
<ns0:AccessOB xmlns:ns0="http://dheeraj/test/VM_ID">
<Row>
<Deptno>10</Deptno>
<Department>Accounts</Department>
<Eno>1001</Eno>
<Ename>Praveen</Ename>
<Designation>CA</Designation>
</Row>
</ns0:AccessOB>


Here i want to mapp from source to Target structures. The target structure should get the values from the source structure when the source structure "dno" value is 10 otherwise it should not get the values into target structure.

Then what is the procedure.

Thanks,
Satish.

Posttop
Alberto MassariSubject: Mapping problem please help me
Author: Alberto Massari
Date: 11 Jun 2007 06:30 AM
Hi Satish,
you can use XSLT Mapper to jump start your transformation:
- load the first XML in the left pane
- load the second XML in the right pane
- right click on the canvas, pick 'Condition Tests', then '='
- drag the Dno element from the left pane to the top input port of the '=' symbol
- double click on the bottom input port of the '=' symbol, and enter 10 in the dialog box
- right click on the canvas, pick 'XSLT Instructions', then 'if'
drag the output port of the '=' symbol to the input port of the 'if'
- drag the output port of the 'if' symbol to the Row element in the right tree
- drag the Dno to the Deptno
- drag the Department to the Department
(at this point I have no idea from where the data for employee data comes from)

Hope this helps,
Alberto

 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.