Hi everyone,
I have two tables, each has one row, table A cannot exist without table B, meaning if Table A has one objective, then there must at least be one KPI (KPI is contained within Table B).
Now I need to create an xsd that complies to this structure, to have a Row within a row. These tables should grow according to the data that is in the xml.
Below is what I've written, but I want the outputType to belong in objective and be a table/row.
<
xsd:complexType name="objective">
<xsd:sequence>
<xsd:element minOccurs="0" maxOccurs="unbounded" name="objectives">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="O1" type="xsd:string" />
<xsd:element name="O1Weight1" type="xsd:integer" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
<
xsd:complexType name="outputType">
<xsd:sequence>
<xsd:element minOccurs="0" maxOccurs="unbounded" name="kpi">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="O1K1Weight1" type="xsd:string" />
<xsd:element name="K1" type="xsd:string" />
<xsd:element name="O1K1Target1" type="xsd:string" />
<xsd:element name="O1K1Source1" type="xsd:string" />
<xsd:element name="O1K1ActualScore" type="xsd:string" />
<xsd:element name="O1K1Notes" type="xsd:string" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:complexType>
</xsd:complexType>
</xsd:complexType>
Views
Replies
Total Likes
I didn't think ComplexType nodes have a name attribute. Normally you do:
To make things easier, why not just make 2 tables? then have table A grow normally and then for each tableA.row, create however many KPIs you need in tableB.row.
Views
Replies
Total Likes
Yes I have two tables already, the challenge is to have Table B belong to Table A in an XSD & both tables should grow automatically depending on the xml data
Views
Replies
Total Likes
here's how I am understanding your issue:
Now I kind of doubt that would work, but you'd need to specify the tables individidually (so not nested):
I omitted types and namespaces, but hopefully that gives you an idea.
Views
Replies
Total Likes
Let me try and see if that will work, thanks.
Views
Replies
Total Likes
Views
Likes
Replies