XML Structure

[Former Member]

Hi,

I am getting the following as structure from external system.

Is it possible to convert this to normal structure via graphical mapping or do we need to use xslt mapping.

<Document>

<data>

<Advice number="18" record-type="A" effective-date="2010-12-15" ></Advice>

<Advice number="20" record-type="A" effective-date="2010-12-15" ></Advice>

<Advice number="22" record-type="A" effective-date="2010-12-15" ></Advice>

</data>

</Document>

All the required data are being filled as attribute rather than as element.

If i need to convert this to the following into normal proxy or file structure

Advicenumber

Recordtype

effectivedate

Is this possible in Graphical Mapping

[Former Member · Accepted solution]

Yes. if it's an xml file then Create data type with Advice as element and the remaining fields as Attributes

And map these attributes to ur proxy structure created.

Normal mapping will do it

[Former Member]

Hi Krish,

If you want to achive your requirement using FCC, then you have to have multi level mapping.

First mapping should convert your attributes to elements and the have FCC to obtain required file format.

Regards

Ramesh