how to create subelements in graphical mapping tool

[Former Member]

Hi

Is it possible to create the following source data type (structure) in graphical mapping tool ?? If possible could you please guide me how to build the same

<Source>

<Line>

<PONumber>490000</PONumber>

<Item>010</Item>

<Material>Bread</Material>

</Line>

<Line>

<PONumber>490000</PONumber>

<Item>020</Item>

<Material>Cheese</Material>

</Line>

<Line>

<PONumber>490001</PONumber>

<Item>011</Item>

<Material>Water</Material>

</Line>

<Line>

<PONumber>490001</PONumber>

<Item>021</Item>

<Material>Beer</Material>

</Line>

<Line>

<PONumber>490001</PONumber>

<Item>031</Item>

<Material>Wine</Material>

</Line>

<Line>

<PONumber>490001</PONumber>

<Item>041</Item>

<Material>Juice</Material>

</Line>

</Source>

thanks

kumar

[justin_santhanam · Accepted solution]

Kumar,

<i> Is it possible to create source data type in mapping tool</i>....

Please correct me if i'm wrong, I think u want the Line element has to be duplicated am i right.

Best regards,

raj.

[Former Member · Accepted solution]

HI raj,

I am beginner ......I don't want anything like duplication of elements. Basically I am not able to create subelements under the root element. Here I have <Line> as subelemt under the root <source>. And again I have ponumber, item, material under the subelement <line>. Please let me know the procedure to create this step by step.

thanks

kumar

[justin_santhanam · Accepted solution]

Kumar,

I'm really not sure whether you want to create the data type for the structure you mentioned , if yer, follow the below steps.

Creat Datatype. In the root tag right click and select

-Insert Subelement -<b>Source</b> (Don't give type ,and choose occurrence as 1)

-Right click on <b>Source</b> click Insert Subelement <b>Line</b> (Don't give type ,and choose occurrence as 0... Unbounded)

- Right click on <b>Line</b> and click element <b>PONumber</b>(Give type and occurrence as 1).

- Right click on <b>Line</b> and click element <b>Item</b>(Give type and occurrence as 1).

- Right click on <b>Line</b> and click element<b> Material</b>(Give type and occurrence as 1).

Hope it helps, if not reply back.

Best regards,

raj.

[Former Member · Accepted solution]

Hi,

I am able to create one particular sub element. But could you please tell me how to create the duplicating of elements ??

thanks

kumar

[justin_santhanam · Accepted solution]

Kumar,

<i>I am able to create one particular sub element. But could you please tell me how to create the duplicating of elements ??</i>

Duplicating, i'm not getting on what context you are saying this,can u please explain.

best regards,

raj

[Former Member · Accepted solution]

Palnati,

In mapping select the node which you want to duplicate. Right click and select Duplicate Subtree.

---Satish

[justin_santhanam · Accepted solution]

Satish,

Do you think its possible on source side to duplicate the node?

Best Regards,

raj.

Message was edited by:

Raj

[Former Member]

Hey

its simple ,first of all create a substructure of the following type

<PONumber>490000</PONumber>

<Item>010</Item>

<Material>Bread</Material>

now create the main structure of following type

<Source>

<Line>

-

---

-

---

over here refer the type for <Line> as the(same place where u select xsd:string,u have this option) subtructure and set the occurence of Line to 1-unbounded

thanx

ahmad