447819_en-US

liliconcom

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

ScriptingRe: Creating a new column from 2 columns with a formula

Not really sure I can understand the logic you have in xlsx file. What do you do when the numbers don't match?

 

You can get last characters of string for example with Right()

Right("PM12", 2); //12

 

Re: Creating a new column from 2 columns with a formula

I want to recreate Column 3 in jmp using columns 1 and 2

Re: Creating a new column from 2 columns with a formula

I used this formula and it works for Lot 1; but I don't know how to expand it for PM01 to PM12 and for Lot 2 and 3.

 

If(
 :Panel Member == "PM01" & :Well # == "A01" | :Panel Member == "PM01" & :Well # == "B01" | :Panel Member == "PM01" & :Well # == "C01" |
 :Panel Member == "PM01" & :Well # == "D01" | :Panel Member == "PM01" & :Well # == "E01" | :Panel Member == "PM01" & :Well # == "F01",
 "Lot 1",
 "TBD"
)

 

Re: Creating a new column from 2 columns with a formula

Based on this, I would say CC Lot# is determined only by Well#