Output · Files

Write Daedalus 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.

Also known as: Hand-off, snapshot

How it works

Type the Daedalus table file name (output.ddtable by default) and pick a Location; blank means the project folder. The node writes the table together with the column formats that Format Table nodes set upstream, such as currency, date patterns, decimals and rules, so a Daedalus Table Reader in another project prints the columns exactly the same way. The write fails if the file already exists unless you tick Overwrite if the file already exists. The file is a DuckDB database underneath, so other tools can open it, but for data handed to tools outside Daedalus use Write Parquet or Write CSV. The written file is passed on downstream as a File.

Inputs and outputs

Settings

{
  fileName: string
  directory?: string
  overwrite?: boolean
}

Example

You prepared and formatted a sales table and a colleague will build the report in their own project. Name the file sales-prepared.ddtable, tick Overwrite if the file already exists, and send them the file; their Daedalus Table Reader picks it up with the formats intact.

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 XML — Saves the table as an XML file with one element per row. Both element names are up to you.
• 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.