# Solutions to "Just KNIME It!" Challenge 24 - Season 2

**URL:** <https://forum.knime.com/t/solutions-to-just-knime-it-challenge-24-season-2/72392>\
**Category:** Just KNIME It!\
**Tags:** justknimeit\
**Created:** [September 6, 2023, 2:07pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-24-season-2/72392 "2023-09-06T14:07:06Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![HeatherPikairos](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/h/a88e4f/32.png) [@HeatherPikairos](https://forum.knime.com/u/HeatherPikairos)\
**Post date:** [September 7, 2023, 1:40pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-24-season-2/72392/5 "2023-09-07T13:40:38Z")

</div>

Hi Everyone 🙂

For this challenge I have separated the email domain from the rest of the email address and used the -GroupBy- node to count the number of times each domain is present in the table. I have then used the -Cross Joiner- node in order to join every email with every other email.

Using the -String Similarity- node, I have calculated the [Levenshtein](https://en.wikipedia.org/wiki/Levenshtein_distance) similarity between every domain and every other domain and have removed rows with similarity equal to 1.

I have then used the -Rule Engine- node to tag the email address as FRAUDULENT or NOT FRAUDULENT based on the following rule:

If the similarity is \> 0.7 AND the domain count of the email \< the domain count of the comparison email then the email is FRAUDULENT. If not, the email is tagged as NOT FRAUDULENT

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/b/f/bff04f541165481ad423ac149007078cca41f257.png)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/4/3/43bad53eda5bd9e18e596be52d24aec81fa1ed3e.png)

You can find my workflow on the hub:

> **[20230907 Pikairos JustKNIMEIt Season 2 Challenge 24 Fraudulent Email Address...](https://hub.knime.com/heatherpikairos/spaces/Public/latest/Just%20KNIME%20It/Season%202/20230907%20Pikairos%20JustKNIMEIt%20Season%202%20Challenge%2024%20Fraudulent%20Email%20Address%20Detection~tXujzhghxm27vjKT)**
>
> In this challenge you will take the role of cybersecurity analyst, and see if you can identify emails that are trying to pass as legitimate when they are in fa…

Best wishes  
Heather

---

_[View the full topic](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-24-season-2/72392)._
