Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to convert the attached T-SQL script to QlikView script, but it's not working. The T-SQL script is developed to generate a Build of Material (BOM) structure. The @ids is the variable which contains ID's from items so it gives the ID's for which a BOM structure should be calculated. The [dbo].[CCM_BOM] table consists of child and parent numbers:
CHILD_PARTNUMBER | PARENT_PARTNUMBER |
123 | 789 |
222 | 789 |
589 | 123 |
So if I execute the T-SQL Script with the @ids = '789' I get following result: (level 0 because its top level)
Item | PARENT_PARTNUMBER | CHILD_PARTNUMBER | Lvl | PARTNUMBER_path |
789 | 789 | 123 | 0 | /789/123 |
789 | 789 | 222 | 0 | /789/222 |
Can you help me converting the script to QlikView script?
Have a look at the following Design Blog post, believe that should help you with things:
https://community.qlik.com/t5/Qlik-Design-Blog/Bill-of-Materials/ba-p/1462792
Regards,
Brett
Hi Brett,
Thanks for the respond, I already looked at it but it will not fullfill my needs. We can have BoM's of more than 50 levels. And parts can be used in multiple BoM's. Levels are not clear, we only have parent child relation.
Regards,
Robbin
I would venture in that case you are likely going to have to start a discussion with your account manager and services to see if they can arrange for one of the consultants to review the use case etc. and see if they can come up with any ideas, I am doubtful Community is going to get you the response you want on this one, as it sounds like this is pretty entailed use case.
Regards,
Brett
Hi Robinho,
Did you find the script needed to explode the BOM? Can you share it?
Thanks,
Wilfredo