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 |