Input · Files

Locra Table Reader

Reads a .ddtable file saved by Write Locra Table, in this project or another one. The column formats come back too, so everything prints as it did.

Also known as: Hand-off, checkpoint

How it works

Pick the file with Choose .ddtable file… in Locra table; Replace… swaps it for another. The column formats and bulk rules saved in the file are restored onto this node, listed under Restored formatting, so every node downstream prints them without a Format Table of its own; to change one, add a Format Table after this node. Re-running reads the file as it is now, so a file exported again upstream is picked up on the next run; when its formats changed since you picked it, the panel warns and Reload formats brings the new ones in.

Inputs and outputs

Settings

Example

A colleague's project ends in Write Locra Table writing monthly-close.ddtable with amounts formatted as currency. Your project starts with this node pointed at that file; the Data tab shows the amounts as currency from the first preview.

More in Files

• CSV Reader — Reads a CSV or other delimited text file, such as a TSV. Column types are detected for you, and you can override them or read every column as text.
• Fixed-width Reader — Reads a text file whose columns sit at fixed character positions, such as a mainframe export or a legacy feed, slicing each line at the positions you set on a ruler over the file's first lines. Header row, start line, encoding and row limit work as in the CSV Reader.
• JSON Reader — Reads a .json, .jsonl or .ndjson file as a table. A JSON array of objects and one-object-per-line files are both detected automatically.
• Parquet Reader — Reads a Parquet file and keeps the column types stored in it.
• Excel Reader — Reads one worksheet of an Excel workbook, the first sheet unless you pick another.
• Geo Reader — Reads a map file with its geometry: GeoJSON, Shapefile (also zipped), GeoPackage, GML, KML/KMZ, GPX, FlatGeobuf or MapInfo TAB. For a file with several layers, you pick which layer to read.
• XML Reader — Reads an XML file into a table. It finds the repeating record element for you, so each record becomes a row.
• SQLite Reader — Reads one table from a local SQLite database file (.sqlite, .sqlite3 or .db). You pick the table from the file's list of tables.