J
Janie
using this schema, I only end up with one record instead of the whole set.
No errors when I map. Just not getting all the data. Where did I goof?
Grateful for guidance -- am feeling like a dog chasing his own tail on this
one.
<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element name="SalesData">
<xsd:complexType mixed="false">
<xsd:sequence>
<xsd:element name="ProductSales">
<xsd:complexType mixed="false">
<xsd:sequence>
<xsd:element name="Product" type="xsd:string"/>
<xsd:element name="Q1" type="xsd:decimal"/>
<xsd:element name="Q2" type="xsd:decimal"/>
<xsd:element name="Q3" type="xsd:decimal"/>
<xsd:element name="Q4" type="xsd:decimal"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
Data set:
<SalesData>
<ProductSales>
<Product>Accessories</Product>
<Q1>45348.94</Q1>
<Q2>44259.23</Q2>
<Q3>28758.21</Q3>
<Q4>26320.19</Q4>
</ProductSales>
<ProductSales>
<Product>Children's Apparel</Product>
<Q1>45322.81</Q1>
<Q2>53029.47</Q2>
<Q3>32576.02</Q3>
<Q4>33142.53</Q4>
</ProductSales>
<ProductSales>
<Product>Garden</Product>
<Q1>35611.09</Q1>
<Q2>23999.28</Q2>
<Q3>22785.63</Q3>
<Q4>25173.19</Q4>
</ProductSales>
<ProductSales>
<Product>Home</Product>
<Q1>29201.29</Q1>
<Q2>20305.00</Q2>
<Q3>14742.02</Q3>
<Q4>19074.30</Q4>
</ProductSales>
<ProductSales>
<Product>Jewelry</Product>
<Q1>110140.09</Q1>
<Q2>89853.67</Q2>
<Q3>34796.02</Q3>
<Q4>64370.13</Q4>
</ProductSales>
<ProductSales>
<Product>Men's Apparel</Product>
<Q1>18264.92</Q1>
<Q2>24214.40</Q2>
<Q3>10288.12</Q3>
<Q4>14263.86</Q4>
</ProductSales>
<ProductSales>
<Product>Shoes</Product>
<Q1>13373.72</Q1>
<Q2>10298.82</Q2>
<Q3>6640.90</Q3>
<Q4>13580.96</Q4>
</ProductSales>
No errors when I map. Just not getting all the data. Where did I goof?
Grateful for guidance -- am feeling like a dog chasing his own tail on this
one.
<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element name="SalesData">
<xsd:complexType mixed="false">
<xsd:sequence>
<xsd:element name="ProductSales">
<xsd:complexType mixed="false">
<xsd:sequence>
<xsd:element name="Product" type="xsd:string"/>
<xsd:element name="Q1" type="xsd:decimal"/>
<xsd:element name="Q2" type="xsd:decimal"/>
<xsd:element name="Q3" type="xsd:decimal"/>
<xsd:element name="Q4" type="xsd:decimal"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
Data set:
<SalesData>
<ProductSales>
<Product>Accessories</Product>
<Q1>45348.94</Q1>
<Q2>44259.23</Q2>
<Q3>28758.21</Q3>
<Q4>26320.19</Q4>
</ProductSales>
<ProductSales>
<Product>Children's Apparel</Product>
<Q1>45322.81</Q1>
<Q2>53029.47</Q2>
<Q3>32576.02</Q3>
<Q4>33142.53</Q4>
</ProductSales>
<ProductSales>
<Product>Garden</Product>
<Q1>35611.09</Q1>
<Q2>23999.28</Q2>
<Q3>22785.63</Q3>
<Q4>25173.19</Q4>
</ProductSales>
<ProductSales>
<Product>Home</Product>
<Q1>29201.29</Q1>
<Q2>20305.00</Q2>
<Q3>14742.02</Q3>
<Q4>19074.30</Q4>
</ProductSales>
<ProductSales>
<Product>Jewelry</Product>
<Q1>110140.09</Q1>
<Q2>89853.67</Q2>
<Q3>34796.02</Q3>
<Q4>64370.13</Q4>
</ProductSales>
<ProductSales>
<Product>Men's Apparel</Product>
<Q1>18264.92</Q1>
<Q2>24214.40</Q2>
<Q3>10288.12</Q3>
<Q4>14263.86</Q4>
</ProductSales>
<ProductSales>
<Product>Shoes</Product>
<Q1>13373.72</Q1>
<Q2>10298.82</Q2>
<Q3>6640.90</Q3>
<Q4>13580.96</Q4>
</ProductSales>