# Parent-Child Hierarchy

**URL:** <https://forum.knime.com/t/parent-child-hierarchy/37698>\
**Category:** KNIME Analytics Platform\
**Created:** [November 30, 2021, 1:26pm UTC](https://forum.knime.com/t/parent-child-hierarchy/37698 "2021-11-30T13:26:35Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![ipazin](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ipazin/32/806_2.png) [@ipazin](https://forum.knime.com/u/ipazin)\
**Post date:** [December 6, 2021, 11:38am UTC](https://forum.knime.com/t/parent-child-hierarchy/37698/4 "2021-12-06T11:38:36Z")

</div>

Hello @dimi,

this topic provides discussion on this topic:

> [@Top parent hierarchy search](https://forum.knime.com/t/top-parent-hierarchy-search/36417):
>
> Hello, I have a table of users and their parents.If the parent is 0, this parent is the top parent of a group. I want to calculate to have for each user, his/her top parent. Example: user | parent 1 | 3 2 | 0 3 | 4 4 | 5 5 | 0 6 | 2 Result user | top\_parent 1 | 5 2 | 2 3 | 5 4 | 5 5 | 5 6 | 2 Do you have any suggestion? Thank you!

Br,  
Ivan

---

_[View the full topic](https://forum.knime.com/t/parent-child-hierarchy/37698)._