Hi everyone,

I have manage to output my file in xml format and to csv format same fime.
However, now I need help to create xml format to look like as my XSD file.
In my orginal mapping and csv output I am having date in the format "20011-02-17" and if I do directly xml schem as what I am having in my mapping I am having xml output of date in the same format.

However, now I would like to split this date "2011-02-17" to be in the format as Year, Month, Date as seperat row like what I am having in my xsd file , see below:

Also I am having in my mapping colum for LongShor data and I would like my output in xml be split as Long one colum, L , Short , S all in different colum.. example below aswell..

If any chance I can do this even if I am not running full version of ToS I am on free one.

Thanks
Zeljka

---date format---

<xs:complexType name="NexusHistoricValue">
        <xs:simpleContent>
            <xs:extension base="xs:decimal">
                <xs:attribute name="year" type="xs:nonNegativeInteger" />
                <xs:attribute name="month" type="xs:positiveInteger" />
                <xs:attribute name="day" type="xs:positiveInteger" />
            </xs:extension>
        </xs:simpleContent>
    </xs:complexType>
-----------------------------------------------------------------------------------------

--- LongShort format -----------------------------

<xs:element name="LongShort">
                <xs:simpleType>
                    <xs:restriction base="xs:normalizedString">
                        <xs:enumeration value="Long" />
                        <xs:enumeration value="L" />
                        <xs:enumeration value="Short" />
                        <xs:enumeration value="S" />
                    </xs:restriction>
                </xs:simpleType>