Script - problem with bill of materials

[jozisvk11]

Hello,

I have data from external database. 

Parent item number	Child item number
T10212578V200522	T10212578V195505
T10212578V200522	T10212578V200605
T10212578V200605	T10212578V200606
T10212578V200605	T10212578V200607

Parent item is T10212578V200522. For T10212578V200522 I have 2 child item number T10212578V195505 and T10212578V200605.

But lower level the parent items are T10212578V195505 and T10212578V200605.  

I need only the highest level T10212578V200522 and then other lower levels together.

So the final table:

Parent item number	Child item number
T10212578V200522	T10212578V195505
T10212578V200522	T10212578V200605
T10212578V200522	T10212578V200606
T10212578V200522	T10212578V200607

Could you ask me, how can i write it in script load ???

Thank you

[JuanGerardo]

Hi @jozisvk11, I suggest you to use the Hierarchy clause: https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/DataSource/hierarchi...

You can build levels based on your parent-child hierarchy, and use the first level to always reference the first ancestor.

JG