When export data is taken from an indirect reference, that reference must provide XML that is structured as an HTML table.
This table structure allows the Spreadsheet Export builder to transform rows and columns in the XML into corresponding rows and columns in the exported spreadsheet. A table structure might not be achievable for all indirect references. The Table Element Names
input is provided so that table-like elements in the XML can be named and handled correctly by the builder.
You use this input to provide a comma-delimited list of XML element names that should be treated as table-like structures. Before performing an export, the builder looks for the named elements and converts them into HTML tables.
The builder looks only at the root element of the XML provided by the indirect reference. If the root element does not have a recognized element name, then the XML is exported as-is. In addition, the root XML element must have a table-like structure. That means it must contain "row" elements that aggregate "column" elements. If this structure is not present, the conversion and export produces unpredictable results.
For convenience, the input contains several names by default. These names identify to the root XML elements used by various data integration builders. Therefore, if a data integration builder provides the indirect reference specified as the Source Reference
input, then the data obtained from this reference should be exportable without needing to specify additional names for the Table Element Names
Parent topic: Spreadsheet Export builder