Hi All,
I have an app where I am trying to create a bill of material for parts that my company needs to rework. I have a table in Dataverse called "AUNA Parts Product Structures" that has each "Parent Part" (PARPRT_02) in a column, and then each "Component Part" (COMPRT_02) in an additional column.
I have loaded the Dataverse table into excel to get a better view. In the image above, the 2 rows with a red dot need to be filtered out inside my app because they are older than the part with the same COMPRT_02. I also filter out any rows with a QTYPER_02 value of 0.
Currently this is all I have been able to come up with. I do not believe I can use the distinct function because I need to keep all the records associated with each part, so I can then lookup the parts that go into the parts that have been filtered out.
I hope this all makes sense.
if anyone has any suggestions or ideas where I could start with this, I would greatly appreciate it.
