Hello,
I have 2 tables:
[BOM list]:
LOAD
[Bill of material],
[Part]
FROM BOM_list.xls
and
[Part List]:
LOAD
[Part],
[Attribute]
From part_list.xls
Each part in [Part List] can have different attributes, example of data:
Part, Attribute
A, small
A, medium
B, medium
B, big
C,small
C,medium
C,big
Example of data in [BOM List]:
Bill of Material,Part
1,A
1,C
2,A
2,B
2,C
I want to find for each [Bill of material] of table [BOM list] the only common attribute for each part.
Example of expected result in a third table:
Table3:
Bill of Material,Attribute
1,small
2,medium
I know I will always have only one attribute which will be common to all parts of a given bill of material. But just in case it would be acceptable if Table 3 contains multiple entries for a given Bill of material in case there are two attributes which are common to the list of part of that BOM.
Thank you for your help
