# Normalize and sum of two similar matrix

**URL:** <https://forum.knime.com/t/normalize-and-sum-of-two-similar-matrix/3762>\
**Category:** KNIME Analytics Platform\
**Created:** [May 24, 2016, 7:32pm UTC](https://forum.knime.com/t/normalize-and-sum-of-two-similar-matrix/3762 "2016-05-24T19:32:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tonio.loconte](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/t/ac8455/32.png) [@tonio.loconte](https://forum.knime.com/u/tonio.loconte)\
**Post date:** [May 24, 2016, 7:32pm UTC](https://forum.knime.com/t/normalize-and-sum-of-two-similar-matrix/3762/1 "2016-05-24T19:32:49Z")

</div>

Hi, I'm beginner of knime. I want check similarity between two or more record of dataset. The problem is that a subset of attribute are categoricals and another subset are numerics.

I thought:&nbsp;

The dataset is compared with cosine similarity for categoricals attributes, on the other hand, numerics attributes of each row is compared with euclidean distance. And so I have two distance matrix one in cosine and one in euclidean.

Now, how I can normalize and sum two distance matrix?

Thanks

---

<div class="post-metadata">

**Author:** ![Iris](https://forum-cdn.knime.com/user_avatar/forum.knime.com/iris/32/14_2.png) [@Iris](https://forum.knime.com/u/Iris)\
**Post date:** [May 25, 2016, 1:05pm UTC](https://forum.knime.com/t/normalize-and-sum-of-two-similar-matrix/3762/2 "2016-05-25T13:05:01Z")

</div>

Hi Toni,

did you already see our distance matrix plugin? There is a node, called the Java Distance, which allows you to define you own distance. Second there is also a Aggregated Distance with which you can combine two distances into one.

Here is the blog post https://www.knime.org/blog/distance-measures-in-knime which we published together with those extensions.

Does this help?

Cheers, Iris

---

<div class="post-metadata">

**Author:** ![tonio.loconte](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/t/ac8455/32.png) [@tonio.loconte](https://forum.knime.com/u/tonio.loconte)\
**Post date:** [May 25, 2016, 5:35pm UTC](https://forum.knime.com/t/normalize-and-sum-of-two-similar-matrix/3762/3 "2016-05-25T17:35:00Z")

</div>

Ok thanks but How normalize &nbsp;two distance matrix before aggregate with "Aggregate Distance"

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 23, 2023, 8:19pm UTC](https://forum.knime.com/t/normalize-and-sum-of-two-similar-matrix/3762/4 "2023-06-23T20:19:36Z")

</div>