cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-661375%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E3%82%AB%E3%83%B3%E3%83%9E%E5%8C%BA%E5%88%87%E3%82%8A%E3%81%AE%E5%88%97%E3%81%AB%E4%B8%80%E8%87%B4%E3%81%99%E3%82%8B%202%20%E3%81%A4%E3%81%AE%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92%E7%B5%90%E5%90%88%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-661375%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%8C%202%20%E3%81%A4%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%202%20%E3%81%A4%E3%81%AE%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92%201%20%E3%81%A4%E3%81%AE%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%AB%E3%83%9E%E3%83%BC%E3%82%B8%E3%81%97%E3%81%9F%E3%81%84%E3%81%AE%E3%81%A7%E3%81%99%E3%81%8C%E3%80%81%E3%82%A6%E3%82%A7%E3%83%BC%E3%83%8F%E7%95%AA%E5%8F%B7%20(%E5%88%97%20%3D%20%E3%82%A6%E3%82%A7%E3%83%BC%E3%83%8F)%20%E3%82%92%E4%B8%80%E8%87%B4%E3%81%95%E3%81%9B%E3%81%9F%E3%81%84%E3%81%A8%E8%80%83%E3%81%88%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%20%E5%8D%98%E4%B8%80%E3%81%AE%E6%9C%80%E7%B5%82%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%AB%E3%81%AF%E3%80%812%20%E3%81%A4%E3%81%AE%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92%E3%83%9E%E3%83%BC%E3%82%B8%E3%81%97%E3%81%9F%E5%BE%8C%E3%81%AB%E5%BE%97%E3%82%89%E3%82%8C%E3%82%8B%E4%B8%80%E6%84%8F%E3%81%AE%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%E3%81%8C%E5%90%AB%E3%81%BE%E3%82%8C%E3%81%A6%E3%81%84%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%20%E3%81%93%E3%81%AE%E6%93%8D%E4%BD%9C%E3%82%92%E5%AE%9F%E8%A1%8C%E3%81%A7%E3%81%8D%E3%82%8B%E6%B1%8E%E7%94%A8%E3%81%AE%20JMP%20%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%82%92%E6%8E%A2%E3%81%97%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%20%E6%9C%80%E7%B5%82%E7%9A%84%E3%81%AA%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%AB%E3%81%AF%E6%AC%A1%E3%81%AE%206%20%E3%81%A4%E3%81%AE%E5%88%97%E3%81%8C%E5%BF%85%E8%A6%81%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%20%3D%202%20%E3%81%A4%E3%81%AE%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%AE%E4%B8%80%E6%84%8F%E3%81%AE%E7%B5%84%E3%81%BF%E5%90%88%E3%82%8F%E3%81%9B%E3%81%8B%E3%82%89%E5%BE%97%E3%82%89%E3%82%8C%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3EW6%20N%20PED%3C%2FP%3E%3CP%3EW6%20O%20PED2%3C%2FP%3E%3CP%3EM6%20AC%3C%2FP%3E%3CP%3EM6%20O%20PED%3C%2FP%3E%3CP%3E%E3%82%A6%E3%82%A8%E3%83%8F%E3%83%BC%E3%82%B9%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E8%A1%A81%EF%BC%9A%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%3C%2FTD%3E%3CTD%3EW6%20N%20PED%3C%2FTD%3E%3CTD%3EW6%20O%20PED2%3C%2FTD%3E%3CTD%3E%E3%82%A6%E3%82%A8%E3%83%8F%E3%83%BC%E3%82%B9%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E01C%3C%2FTD%3E%3CTD%3ENIT7%3C%2FTD%3E%3CTD%3ET60%3C%2FTD%3E%3CTD%3E5%E3%80%818%E3%80%8113%E3%80%8120%E3%80%8125%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E02E%3C%2FTD%3E%3CTD%3ENIT6%3C%2FTD%3E%3CTD%3ET62%3C%2FTD%3E%3CTD%3E2%E3%80%817%E3%80%8110%E3%80%8111%E3%80%8114%E3%80%8115%E3%80%8117%E3%80%8118%E3%80%8119%E3%80%8121%E3%80%8122%E3%80%8124%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E03E%3C%2FTD%3E%3CTD%3ENIT7%3C%2FTD%3E%3CTD%3ET62%3C%2FTD%3E%3CTD%3E3%E3%80%814%E3%80%8112%E3%80%8116%E3%80%8123%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E8%A1%A8%202%3A%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%E3%82%B0%E3%83%AB%E3%83%BC%E3%83%97%3C%2FTD%3E%3CTD%3EM6AC%3C%2FTD%3E%3CTD%3EM6%20O%20PED%3C%2FTD%3E%3CTD%3E%E3%82%A6%E3%82%A8%E3%83%8F%E3%83%BC%E3%82%B9%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E01C%3C%2FTD%3E%3CTD%3EcN%3C%2FTD%3E%3CTD%3E%C3%9730%3C%2FTD%3E%3CTD%3E5%E3%80%8120%E3%80%8124%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E02E%3C%2FTD%3E%3CTD%3EcN%3C%2FTD%3E%3CTD%3E%C3%9730%3C%2FTD%3E%3CTD%3E11%E3%80%8118%E3%80%8119%E3%80%8122%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E03E%3C%2FTD%3E%3CTD%3E2A%3C%2FTD%3E%3CTD%3E%C3%9730%3C%2FTD%3E%3CTD%3E8%E3%80%8113%E3%80%8116%E3%80%8117%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E04E%3C%2FTD%3E%3CTD%3E2A%3C%2FTD%3E%3CTD%3E%C3%9730L%3C%2FTD%3E%3CTD%3E1%E3%80%819%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E05E%3C%2FTD%3E%3CTD%3E2A%3C%2FTD%3E%3CTD%3E25A%3C%2FTD%3E%3CTD%3E2%E3%80%814%E3%80%8110%E3%80%8121%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E06E%3C%2FTD%3E%3CTD%3E2A%3C%2FTD%3E%3CTD%3E25A%3C%2FTD%3E%3CTD%3E7%E3%80%8114%E3%80%8123%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E07E%3C%2FTD%3E%3CTD%3E2A%3C%2FTD%3E%3CTD%3E100A%3C%2FTD%3E%3CTD%3E3%E3%80%8112%E3%80%8115%E3%80%8125%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-661375%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E8%87%AA%E5%8B%95%E5%8C%96%E3%81%A8%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E4%BD%9C%E6%88%90%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E5%9F%BA%E6%9C%AC%E7%9A%84%E3%81%AA%E3%83%87%E3%83%BC%E3%82%BF%E5%88%86%E6%9E%90%E3%81%A8%E3%83%A2%E3%83%87%E3%83%AA%E3%83%B3%E3%82%B0%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E5%AE%9F%E9%A8%93%E8%A8%88%E7%94%BB%E6%B3%95%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-661390%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E3%82%AB%E3%83%B3%E3%83%9E%E5%8C%BA%E5%88%87%E3%82%8A%E3%81%AE%E5%88%97%E3%81%AB%E4%B8%80%E8%87%B4%E3%81%99%E3%82%8B%202%20%E3%81%A4%E3%81%AE%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92%E7%B5%90%E5%90%88%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-661390%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E7%B5%90%E5%90%88%E3%81%95%E3%82%8C%E3%81%9F%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%8C%E3%81%A9%E3%81%AE%E3%82%88%E3%81%86%E3%81%AB%E3%81%AA%E3%82%8B%E3%81%AE%E3%81%8B%E7%90%86%E8%A7%A3%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%20%E3%82%B5%E3%83%B3%E3%83%97%E3%83%AB%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%81%8B%E3%82%89%E5%B0%91%E3%81%AA%E3%81%8F%E3%81%A8%E3%82%82%E9%83%A8%E5%88%86%E7%9A%84%E3%81%AA%E4%BE%8B%E3%82%92%E6%8F%90%E4%BE%9B%E3%81%97%E3%81%A6%E3%81%8F%E3%81%A0%E3%81%95%E3%81%84%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E
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