Distance Matrix Writer

Writes the content of a distance matrix column to an output file or a remote location denoted by a URL. The output file will contain a row key column and a triangular distance matrix, i.e. each row contains the distances to the rows succeeding it.
Note that if the destination location is a remote URL not all options are available because in general it's not possible to determine whether the remote location exists. In this case it will always be overwritten.

Options

Output file
Select the output location here. If the file name ends with ".gz", the file will be compressed.
If output file already exists
How to handle local output file already existing.
  • Fail: Prevent node from executing.
  • Overwrite file: Replace the file if it exists.
Distance matrix column
Select the column containing the distance values.
Chunk size
Does not have any influence on the outcome. It is used to reduce the amount the table is iterated. Increasing the chunk size will also increase the memory usage.
Write column header
Include column header in the output.
Write row header
Include row header in the output.
Separator char
The character used to separate entries in the table.
Matrix type
Choose how to write the distance matrix.
  • Lower triangular: Lower triangular matrix, where the first row will contain zero or one entry and each consecutive row one more entry than the previous row. This option should only be enabled if the distances are symmetric.
  • Upper triangular: Upper triangular matrix, similar to lower triangular but written in the opposite direction.
  • Full matrix: Full matrix, which includes the diagonal and each row will have the same number of entries.
Write diagonal values
Write also the diagonals when writing one of the triangular matrices.

Input Ports

Icon
A table with at least one distance matrix column.

Output Ports

This node has no output ports

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.