BookmarkSubscribeRSS Feed
hacketkm

Community Trekker

Joined:

Sep 14, 2012

Help with an IF() statement?

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

Column 1Column 2
A1
B2
UNKNOWN
C3

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
thechadd

Community Trekker

Joined:

Jun 23, 2011

Solution

Re: Help with an IF() statement?

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
thechadd

Community Trekker

Joined:

Jun 23, 2011

Solution

Re: Help with an IF() statement?

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.