Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I'm attempting to perform a bill of materials explosion in QV using Hierarchy & HierarchyBelongsTo. My data looks something like this:
Parent | Child | Type | Qty |
A | B | Make | 2 |
A | E | Buy | 1 |
A | F | Buy | 1 |
B | C | Make | 2 |
C | D | Buy | 2 |
D | G | Make | 1 |
G | H | Buy | 1 |
My goal it to get a flat table depicting the total BOM structure. The resulting table would look something like this:
Parent | Child | Type | Qty | Level |
A | A | Make | 1 | 0 |
A | B | Make | 2 | 1 |
A | C | Make | 4 | 2 |
A | D | Buy | 8 | 3 |
A | E | Buy | 1 | 1 |
A | F | Buy | 1 | 1 |
B | B | Make | 1 | 0 |
B | C | Make | 2 | 1 |
B | D | Buy | 4 | 2 |
D | D | Make | 1 | 0 |
D | G | Make | 1 | 1 |
D | H | Buy | 1 | 2 |
G | G | Make | 1 | 0 |
G | H | Buy | 1 | 1 |
Any idea?
See: Bill of Materials
- Marcus