Creating a new column from 2 columns with a formulaHi,
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
Consumer and Market ResearchData Blending and CleanupRe: Creating a new column from 2 columns with a formulaSince you have few levels of Lots, you can recode the data to a new column and JMP will create the formula for you.
Re: Creating a new column from 2 columns with a formulaHi Meda
Pls refer to annex files and click '+' after column check formula.
Have a nice day.
Re: Creating a new column from 2 columns with a formulaOk I got it thank you so much!
Re: Creating a new column from 2 columns with a formulaAttachment in previous post (Sheet1.jmp) has one idea for it
Re: Creating a new column from 2 columns with a formulaOk, can you then write a formula to recreate column 3 by well#
Re: Creating a new column from 2 columns with a formulaBased on this, I would say CC Lot# is determined only by Well#
Re: Creating a new column from 2 columns with a formulaI 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 formulaI want to recreate Column 3 in jmp using columns 1 and 2
Re: Creating a new column from 2 columns with a formulaNot 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
