cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
pankajsync
Level I

how to I combine two table matching a comma separated column

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: 

GroupW6 N PEDW6 O PED2Wafers
01CNIT7T605, 8, 13, 20, 25
02ENIT6T622, 7, 10, 11, 14, 15, 17, 18, 19, 21, 22, 24
03ENIT7T623, 4, 12, 16, 23

 

Table 2: 

GroupM6 ACM6 O PEDWafers
01CcNx305, 20, 24
02EcNx3011, 18, 19, 22
03E2Ax308, 13, 16, 17
04E2Ax30L1, 9
05E2A25A2, 4, 10, 21
06E2A25A7, 14, 23
07E2A100A3, 12, 15, 25
1 REPLY 1
txnelson
Super User

Re: how to I combine two table matching a comma separated column

I am not understanding what the merged table will look like. Please provide at least a partial example, from your example tables, would look like.

Jim