@Ksharp Thank you Is there any way to do this where not every path is created for example what if I only want to lookup paths for 2 and 10 which would make the output: 1|2 1|2|3|6|10 I don't need all paths from the source table.
... View more
@Ksharp One to many match. Also still need a way to resolve only looking for a select few bottom levels. My table is about 30 million rows.
... View more
@hashman: Thanks for your help! using these functions are very new to me. but is there a way to set a where statement in here, to only run up the bill of material on a select few bottom level children parts . For example if I only wanted to know the top level of 1d1, and not 1i1. There are just too many BOMs in my table to go through instance.
... View more
I am trying to create a code that will give me all the top level parts from using a bill of Material table I have. The table is set up similar to what I have shown below, basically I need to go from the very bottom to the top. I am just not sure where to start, also the actual table will not be ordered where a whole bill of material is shown row after row.
... View more
I am trying to figure out a way to concatenate a set of columns, while skipping some when the value = "no". Unfortunately because of how the entire program is structured I am unable to change the no values to null. Please let me know.. Thanks
... View more