Is there anyway to create a new QVD based on an existing QVD? Here is my issue:
I have a QVD file that has three variables I need. Manufactured P/N, Sub-level P/N, and Net Qty. It's a one to many scenario. If I do a basic LOAD, I only get the first level of parts it takes to build the manufactured P/N. That first level may have a subset of parts and the next level until I get to all the basic purchase parts.
My end result should be a table that can tell me ALL the parts including subset parts and qty needed to build the Manufactured P/N. This would require continually loading the QVD until nothing remains except Purchase Parts.
I have attached my file but it doesn't tell you much. I can add in The Make/Purchase designator if that helps. I also attached an excel file with an example of the data set since I can't attached the full QVD.