Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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