Forum Discussion
Single level Bill of Material pulled into Excel Power Query - How can I make Multi level BOM Table
I have a data pull from my erp system that comes through the odbc connectivity through power query into an excel workbook for all of our bill of materials. It is a single level pull. I need to figure...
I used your problem as a test of the applicability of Lambda function.
Unfortunately I may have gone in the wrong direction, starting with a database parent-child table and breaking it down to a single list of quantities.
SergeiBaklan Since the main relationships are recursive in nature, I wondered whether functional programming and Lambdas may work better than VBA and an imperative programming. At the moment debugging is hard work!
PeterBartholomew1 Thank you for the quick response. As soon as I get a chance I will work through this to see what I can manage with it. I appreciate your help.