Discussions

Solve problems, and share tips and tricks with other JMP users.

Level III

Oct 19, 2012 10:47 AM (10386 views)

I would like to use an IF() statement to assign a value to a column if another column meets a certain requirement.

D = 100;

IF( :Column 1 == "UNKNOWN", :Column 2 = D);

The script isn't recognizing D as the value "100". Could anyone help me out?

1 ACCEPTED SOLUTION

Accepted Solutions

Oct 19, 2012 12:53 PM (12973 views) | Posted in reply to message from hacketkm 10-19-2012

You just need to address it by row.

D =100;
for each Row(
if(:"Column 1"[]=="UNKNOWN",:"Column 2"[] = D
)
)

The other option is to create a new column with a formula. Then your solution would work.

1 REPLY 1

Oct 19, 2012 12:53 PM (12974 views) | Posted in reply to message from hacketkm 10-19-2012

You just need to address it by row.

D =100;
for each Row(
if(:"Column 1"[]=="UNKNOWN",:"Column 2"[] = D
)
)

The other option is to create a new column with a formula. Then your solution would work.

Help with an IF() statement?