0 ×

**KNIME Distance Matrix Extension** version **4.2.1.v202008251158** 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.

- Distance Matrix Calculate (47 %)
- Distance Matrix Reader (9 %)
- Distance Matrix Pair Extractor (5 %)
- k-Medoids (3 %)
- Column Filter (3 %) Streamable
- Show all 45 recommendations

- CSV Reader (27 %)
- Distance Matrix Reader (27 %)
- File Reader (18 %) Streamable
- Python Edit Variable (9 %)
- Aggregated Distance (5 %)
- Show all 8 recommendations

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

KNIME 4.2

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.

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.

Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com, follow @NodePit on Twitter, or chat on Gitter!

Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.