# String to Date&Time

**URL:** <https://forum.knime.com/t/string-to-date-time/57772>\
**Category:** KNIME Analytics Platform\
**Created:** [December 30, 2022, 3:56pm UTC](https://forum.knime.com/t/string-to-date-time/57772 "2022-12-30T15:56:54Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [January 1, 2023, 12:59pm UTC](https://forum.knime.com/t/string-to-date-time/57772/8 "2023-01-01T12:59:12Z")

</div>

@My_Rebecca you could take a look at this article:

> [@School of duplicates - and how to deal with them](https://forum.knime.com/t/school-of-duplicates-and-how-to-deal-with-them/24164):
>
> Dealing with duplicates is a constant theme with data scientist. And a lot of things can go wrong. The easiest ways to deal with them is SQL’s GROUP BY or DISTINCT. Just get rid of them and be done. But as this examples might demonstrate this might not always be the best option. Even if your data provider swears your combined IDs are unique especially in Big Data scenarios there might still be lurking some muddy duplicates and you should still be able to deal with them. And you should be able t…

If it is a more complicated task of de-duplications window functions are one option:

> **[use H2 to produce a Position / Rank number within a group variable (window...](https://hub.knime.com/mlauber71/spaces/Public/forum/kn_forum_31608_h2_group_rank_window_function~W6pGUf-DhT3OQALr/current-state)**
>
> use H2 to produce a Position / Rank number within a group variable (window functions) use custom JDBC driver - THX tobias.koetter for the hint

---

_[View the full topic](https://forum.knime.com/t/string-to-date-time/57772)._