- This topic has 6 replies, 1 voice, and was last updated 8 years, 4 months ago by
.
-
Posts
-
-
Dear All,
I want to know if I can to select rows of a element mapping a schema in an other one.
For instance:
I want to map Schema A.xsd (according to A.xml) to B.xsd to get B.xml whithout using emty elementa or element with nil property.
A.xml look like this:
<Root_A>
<Column1> <Row>HH</Row> <Row>FF</Row> <Row>GG</Row> </Column1>
<Column2> <Row>HH</Row> <Row>FF</Row> <Row>GG</Row> </Column2>
</Root_A>
The result of mapping must be B.xml:
<Root_B>
<Column1> <Row>FF</Row> <Row>GG</Row> </Column1>
<Column2> <Row>HH</Row> <Row>FF</Row> <Row>GG</Row> </Column2>
</Root_B>
Thanks in advance
-
Hi Hiwa.
I don’t know I get you right and I don’t know what you will do after mapping.
But if you declare the <Row> as a Attribute of the Element <ColumnX> so you can fill it just if the source is filled otherwise it will not seen in the output xml file. But I’m not sure if this helps in your scenario. Also I’m not sure if it exist a property for your issue in the destination element.
Hope it helps or give some other ideas.
Wolfgang
-
Hi Wolfgang, thanks a lot.
But the Schemas are fix.
The question to ask is if there is a way to manipulate the iteration of a elemnt in destination.
For example:
We have: <Column1> <Row>HH</Row> <Row>FF</Row> <Row>GG</Row> </Column1>
<Row> has been repeated three times with different values (Row apreare only once in <Column1> with MinOccurs=0 and Max Occurs=unbounded in Schema A.xsd).
Now if I want to map <Row> (in A.xml) to <Row> (in B.xml) then the Iteration of <Row> in B.xml will be also setted to 3. In the next Step the values for this three elements (if nil, emty or something else) will specified.
My question is now, if I can prevent this method by mapping.
-
Hi Hiwa,
So let me get this straight: the only difference between schema A and schema B is that you don’t want to map the Row element containing value HH in the Column1 record in schema A to any element in schema B, is that correct?
You can use a combination of Logical and Value Mapping functoids to achieve that in a map.
Daniel.
-
Hi Daniel, thanks for answer!
that’s correct…
I have tried to get a <Row> element as emty or nil element but I was not able to suppress this element in destination completely.
-
Hi Hiwa.
In case you didn’t know exactly how often the Element <Row> in the source will appear, I would try first the logical functoid to check if a value exist in the source field/element (logical existance/logical string). And if there is a value you can loop it in your destination schema. And then you will only have the <Rows> you like in the destination schema.
Or you can check with the equal functoid the existance of a value like “HH” in an element first and then you can decide to loop it or not.
Wolfgang
-
Hi Hello Everyone ,
This is Nicole Anderson and am new to this Forum . I think you can fill it just if the source is filled otherwise it will not seen in the output XML file . But am not sure if this help’s in your account . And i would like to ask more from you …..
______________________________________________________________________
Discover the hidden
source of targeted traffic that unearths eager buying customers, drives
them straight to your site, and literally explodes your profits almost
overnight at just simple click [url=http://uniquearticlepro.com/] unique
article wizard.[/url]
-
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.