Iterative Loop on a Single QVD

Thu, 27 Apr 2017 18:06:55 GMT

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.

topic Iterative Loop on a Single QVD in QlikView

Iterative Loop on a Single QVD