0 Replies Latest reply on Sep 14, 2011 1:41 PM by no2morrow

    Issues with XML Data, getting columns not rows

    no2morrow

      I have a form that is formatted very similarly to the example below.  When the data from my form is submitted, the second table is given as extra columns instead of as a row.

       

      Example:

      https://acrobat.com/app.html#d=4Nj*BeqL1iG-6tfQBLoIfA

       

      Using that example, let's say I am buying 1 Appple at .59 ech, 2 Oranges at .24 each, and 3 bottles of Saint-Emillion for 7.99 each.

       

      Ideally when I submit the data I would have an XML table that is readably by Excel as something like this:

       

      ItemQuantityPriceAmount
      Apples1.59.59
      Oranges2.49.48
      Saint-Emillion37.9923.97

       

       

      Instead, when I open the XML file in Excel I get a table that looks like this.  It lumps the Fruit data in columns to the right of the Wine columns.

       

       

      ns1:dataNodens1:dataNode2ns1:dataNode3subTotalns1:dataNode4Totalitemquantitypriceamountitem5quantity6price7amount8
      dataGroupdataGroupdataGroup23.97dataGroup25.04110.590.59137.9923.97
      dataGroupdataGroupdataGroup23.97dataGroup25.04220.240.48137.9923.97

       

      How would I go about rectifying this?