nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Creating a new column from 2 columns with a formula

Meda

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

For JMP community.xlsx

Accepted answers

All comments

jthi

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

Meda

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

Meda

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"
)

jthi

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

Sheet1.jmp

Meda

Ok, can you then write a formula to recreate column 3 by well#

frank_wang

Hi Meda

Pls refer to annex files and click '+' after column check formula.

Have a nice day.

Formula of new col.jmp

Capture.JPG

arooqi

Since you have few levels of Lots, you can recode the data to a new column and JMP will create the formula for you.