Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Bills of Materials - explode to buy out level?

We use Syspro as our ERP System. The data is stored in a sequel DB.

The table contains the Parent Part and its components - the problem is that some components must be exploded further to get to the lowest level of the BOM which is called the Buy out level.

So what i need at the end is a table with the parent and all its components where the part category = B - this replacing all components that are <> part category B by their components hence if the components part category <>B it becomes a parent etc

It all sounds to much like a circular reference for my brain - Any ideas?

Community Browser