I have two tables. I would like to merge the two table into single table but would like to match the wafer numbers (Column = Wafers). The single final table should have unique groups which may have resulted after merging two tables. I am looking for generic JMP script which can perform this operation. The final table should have these 6 columns :
Group = Resulting from unique combinations of two tables.
W6 N PED
W6 O PED2
M6 AC
M6 O PED
Wafers
Table 1:
Group | W6 N PED | W6 O PED2 | Wafers |
01C | NIT7 | T60 | 5, 8, 13, 20, 25 |
02E | NIT6 | T62 | 2, 7, 10, 11, 14, 15, 17, 18, 19, 21, 22, 24 |
03E | NIT7 | T62 | 3, 4, 12, 16, 23 |
Table 2:
Group | M6 AC | M6 O PED | Wafers |
01C | cN | x30 | 5, 20, 24 |
02E | cN | x30 | 11, 18, 19, 22 |
03E | 2A | x30 | 8, 13, 16, 17 |
04E | 2A | x30L | 1, 9 |
05E | 2A | 25A | 2, 4, 10, 21 |
06E | 2A | 25A | 7, 14, 23 |
07E | 2A | 100A | 3, 12, 15, 25 |