Hello,
I have a bit of a dilemma. In the application am trying to determine if component is only in products selected in one table compared to another. The base data is similar, linked through the component
I am filtering the first table by Product and as a result, i would need a list of Components, which are ONLY included in the filtered components from table one.
as an example the Product filter for table 1 would return the following:
| Product | Component |
|---|
| Car 1 | Piston 1 |
| Car 2 | Piston 1 |
| Car 3 | Piston 1 |
| Car 1 | Wheel 2 |
| Car 2 | Wheel 3 |
| Car 3 | Wheel 2 |
As the table 2 has same data- linked through the component, it would return i.e. like this
| comparison product | component |
|---|
| Car 1 | Piston 1 |
| Car 2 | Piston 1 |
| Car 3 | Piston 1 |
| Car 4 | Piston 1 |
| Car 5 | Piston 1 |
| Car 1 | Wheel 2 |
| Car 2 | Wheel 3 |
| Car 3 | Wheel 2 |
| Car 8 | Wheel 2 |
| Car 99 | Wheel 4 |
| Car x | Wheel 9 |
In this case, the result would be that Piston 1 and wheel 2 are not ONLY in filtered products and Wheel 3 IS ONLY in the filtered products (scenario 1)
the Table 2 is also filterable as the comparison group can change, so for example if the table 2 filter would eliminate Car 8, that would mean the Wheel 2 would be also ONLY in the filtered products (scenario 2)
The end result should be a table like this
in scenario 1
| Component | ONLY in selected products? |
|---|
| Piston 1 | NO |
| Wheel 2 | NO |
| Wheel 3 | YES |
in scenario 2 (with filtered comparison products, Car 8 eliminated)
| component | Only in table selected products? |
|---|
| Piston 1 | NO |
| Wheel 2 | YES |
| Wheel 3 | YES |
I have not found a way to do this. Any help appreciated.
