Output · Files

Write XML

Saves the table as an XML file with one element per row. Both element names are up to you.

Also known as: XML feed

How it works

Type the XML file name (output.xml by default) and pick a Location; blank means the project folder. Root element names the element that wraps the document (rows by default) and Row element the element written once per row (row by default); each column becomes a child element of the row. The write fails if the file already exists unless you tick Overwrite if the file already exists. Write formatted values writes values as they print upstream instead of raw numbers. The written file is passed on downstream as a File.

Inputs and outputs

Settings

{
  fileName: string
  directory?: string
  rootElement?: string
  rowElement?: string
  overwrite?: boolean
  formatValues?: boolean
}

Example

An accounting system imports invoices as XML. Set Root element to invoices and Row element to invoice, so a table with id and total columns is written as:

<invoices><invoice><id>1042</id><total>99.5</total></invoice>...</invoices>

More in Files

• Write CSV — Saves the table as a CSV file. It can create a new file, replace one (keeping a backup) or append to it; the delimiter, header and quoting are up to you.
• Write Excel — Writes one or more tables into named sheets of an Excel workbook. It can add to an existing workbook and keep its other sheets.
• Write JSON — Saves the table as a JSON file: one array of objects, or one object per line.
• Write Parquet — Saves the table as a compressed Parquet file that reloads fast here, in DuckDB, pandas or Spark. Good for large in-between results.
• Write HTML — Saves the table as a plain HTML page with one table and an optional title. For a styled report, use Write Report.
• Write Geo File — Saves a table with geometry as GeoJSON, GeoPackage, Shapefile or GeoParquet, ready to open in QGIS or ArcGIS. GeoParquet takes lon/lat data only.
• Write Locra Table — Saves the table with its column formats into one .ddtable file, so a colleague can pick it up in another project and see it printed the same way.