Script - problem with bill of materials

jozisvk11 — Mon, 20 Dec 2021 21:30:03 GMT

Hello,

I have data from external database.

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:

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

Thank you

Re: Script - problem with bill of materials

JuanGerardo — Mon, 20 Dec 2021 21:39:38 GMT

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