0 ×

Distance Matrix Writer

KNIME Distance Matrix Extension version 4.3.0.v202011191420 by KNIME AG, Zurich, Switzerland

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.


Output File
Select the output location here. If the file name ends with ".gz", the file will be compressed.
Distance Matrix Column
Select the column containing the distance values.
Write Column/Row Header
Select this to include column and/or row header.
Separator Char
The character used to separate entries in the table.
Overwrite OK
Check this if an existing file may be overwritten (otherwise the execution will fail to prevent unintentional overwrite)
Writer Lower Triangular Matrix
Write the lower triangular matrix, that is, the first row will contain zero or one entry (depending on whether the diagonal is to be written) and each consecutive row one more entry than the previous row. This option should only be enabled if the distances are symmetric.
Writer Upper Triangular Matrix
Similar to above, just write the upper triangular matrix.
Writer Full Matrix
Write full matrix. This implies that also the diagonal is written and each row will have the same number of entries.
Writer diagonal values
Write also the diagonals when writing one of the triangular matrices.
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.

Input Ports

A table with at least one distance matrix column.

Best Friends (Incoming)

Best Friends (Outgoing)


To use this node in KNIME, install KNIME Distance Matrix from the following update site:


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


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.