on 08-09-2007 10:49 AM
aname|bname|caddress|dcity
aziz |khan |bng |bly
aziz |khan |bng |bly
aziz |khan |bng |bly
aziz |khan |bng |bly
aziz |khan |bng |bly
aziz |khan |bng |bly
aziz |khan |bng |bly
aziz |khan |bng |bly
aziz |khan |bng |bly
aziz |khan |bng |bly
this is my sample source data which is to be mapped to only to two feilds ie aname,dcity but after data is picked up and given to target side i get the target data as shown below
aname|aziz|aziz|aziz|aziz|aziz|aziz|aziz|aziz|aziz|aziz
in the above format.
the source data is picking all my adapter engines are ok
hi ,
this is my message mapping ( source side)
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http:
filedetails.com" targetNamespace="http:
filedetails.com">
<xsd:element name="MT_file_source" type="DT_file_source" />
<xsd:complexType name="DT_file_source">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">
99904652466611dcc23600179a7fc32a
</xsd:appinfo>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="file_source" minOccurs="0" maxOccurs="unbounded">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">
ea20e3e0463411dc927300195bd04f1c
</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="root" minOccurs="0" maxOccurs="unbounded">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">
4fdda8d0463511dccb4c00195bd04f1c
</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="aname" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">
4fdda8d1463511dc85b700195bd04f1c
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="bname" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">
4fdda8d2463511dc8c9800195bd04f1c
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="caddress" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">
4fdda8d3463511dc9d5900195bd04f1c
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="dcity" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">
4fdda8d4463511dc97bd00195bd04f1c
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:schema>
this is my message mapping on (target side)
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http:
filedetails.com" targetNamespace="http:
filedetails.com">
<xsd:element name="MT_file_target" type="DT_file_target" />
<xsd:complexType name="DT_file_target">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">
9a370da2466611dc8b9800179a7fc32a
</xsd:appinfo>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="file_target" minOccurs="0" maxOccurs="unbounded">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">
8b524d30463511dca2a300195bd04f1c
</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="root" minOccurs="0" maxOccurs="unbounded">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">
8b524d31463511dcc57200195bd04f1c
</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="aname" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">
8b524d32463511dccdf700195bd04f1c
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="dcity" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">
8b524d33463511dcbf7500195bd04f1c
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:schema>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
keep the occurance of the aname and the dcity as 1 or 1..n
if this does not help u... give more details on the mapping u have used
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.