Hi,
I would like to use a couple of =IF(A=B,1,0) type formulas within my output data and i would like the result to be displayed in its own column, which tool is the best to use?
Hi @yzhang,
For a record by record test, you may be able to accomplish this with a multi-part conditional statement for each of the 3 tests. If you need to compare all of the data points from fields [a], [c] & [e] then you can approach the problem with a series of Find & Replace tools, which can search for a match in any part of the cell for [z]:
Use a Formula tool with an IF function
IF c THEN t ELSE f ENDIF
IF c THEN t ELSEIF c2 THEN t2 ELSE f ENDIF
Chris
Hi, @yzhang
I will offer that you start with the Formula Tool.
Also, based on your sample logic statement, you're looking for an IIF type argument and not IF.
However, if you're going to assess more conditions than IIF will comfortably allow and return results in the same column, then you want IF THEN ELSEIF type arguments. Good luck!
if i want to see whether the item in column A is within in column B, and loop in other similar, would formula tool still be best?
