Binding and XML Data

[meem23]

Hi Experts,

I’m creating a table and would like to use XML data that is used in a different form to populate fields.

This is an example of what the table would look like.  The highlighted data is what would be populated from the XML data.  The table is static and not dynamic.

This is an example of what the xml looks like:

<dataroot>

     <Schedules>

          <ScheduleID>MO1</ ScheduleID >

          <FieldA>9.0000%</FieldA>

          <FieldB>5.0000%</FieldB>

     </Schedules>

     <Schedules>

          <ScheduleID>MO2</ ScheduleID >

          <FieldA>8.5000%</FieldA>

          <FieldB>4.5000%</FieldB>

     </Schedules>

</dataroot>

Can I bind the fields?

How would I go about doing this if FieldA is needed for Qtr 1 row and FieldB is for Qtr 2 row? Binding fields rather than using JavaScript code would be best, but if a script is needed, can I get some guidance in what this script would look like as I'm not a programmer and have little scripting knowledge.

[_Bruce_Robertson · Accepted solution]

Hi,

If your table is static then could you have two body rows.  The binding expression for MO1 in the first body row would be "$.Schedules[0].FieldA" , MO2 would be "$.Schedules[1].FieldA", then for the second row use "$.Schedules[0].FieldB" and "$.Schedules[1].FieldB".

Bruce

[meem23]

This works. Thanks for your help!