Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events

Issues with XML Data, getting columns not rows

Avatar

Level 2

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?

0 Replies