how to I combine two table matching a comma separated column

pankajsync — Sun, 23 Jul 2023 00:11:33 GMT

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

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

txnelson — Sun, 23 Jul 2023 01:34:19 GMT

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.

topic how to I combine two table matching a comma separated column in Discussions

how to I combine two table matching a comma separated column

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