Creating a new column from 2 columns with a formula
Hi, Can someone help me write a code in JMP to recreate Column 3 in the attached file. Column 3 was derived from columns 1 and 2. Basically if Column 1 is "PM01" and Column 2 is "A01" or "B01" or "C01" or "D01" or "E01" or "F01", then Column 3 will be "Lot 1" and so on. Best,Meda