How to map

Viewing 1 reply thread
  • Author
    Posts
    • #13686

      I have the following table structure (quert_table,rowcount,field1, field2, field 3.etc.)

      and a schema –

      – <xsd:element name=\”rfc_read_table\” nillable=\”true\”>
      – <xsd:complexType>
      – <xsd:sequence>
      – <xsd:element name=\”query_table\” nillable=\”true\”>
      <xsd:element name=\”rowcount\” nillable=\”true\” type=\”RFC:long_seq\” />
      <xsd:element name=\”fields\” nillable=\”true\”
      </xsd:sequence>
      </xsd:complexType>
      </xsd:element>

      I would like to populate the “fields” sections from the table. But my problem is there are many fields in the table, but only 1 spot to map them in the schema.

      Could any one help me how to do this.

      Thanks

    • #13687

      If i understand correctly then you want to map all the fields in single child element of your schema.
      Once you use SQL Adapter it will create a scema of your table you just mentioned then you need to use mapper to create mapping of your table’s fields and your schema single fields.
      If your requirement is to mapp all the table fields into a single child element in your schema then you can use String Concat Functoid in the mapper to concat all the fields into single child element.

      If you need any help let me know.

      Regards,
      Naseem Siddiqui

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.