IF ELSEIF error - malformed - IN A FILTER

Question

I want to filter out a few ranges of data. I'm using the Filter tool with an IF/ELSEIF - but getting error. What is wrong with this IF ELSEIF? IF [Enc - MS DRG] >= 765 OR <= 795 THEN f ELSEIF [Enc - MS DRG] >= 876 OR <= 897 THEN f ELSEIF [Enc - MS DRG] >= 945 OR <= 946 THEN f ELSEIF [Enc - MS DRG] >= 949 OR <= 950 THEN f ELSE t ENDIF Enc - MS DRG is data type of Double. Error is: Parse Error at Char (25): Malformed IFStatement

JohnJPS · Accepted Answer

Two approaches - you could replace them with "f" in quotes, so that it's a string rather than the unassigned variable f; (same with "t" vs. t) Or, probably better: you can set the Output Field type to "Bool ", and in the conditional logic, replace the f with 0, and the t with 1: IF [Time] >= 765 OR [Time] <= 795 THEN 0 ELSEIF [Time] >= 876 OR [Time] <= 897 THEN 0 ELSEIF [Time] >= 945 OR [Time] <= 946 THEN 0 ELSEIF [Time] >= 949 OR [Time] <= 950 THEN 0 ELSE 1 ENDIF That way - as you describe your wishes, you can treat the variable downstream as a boolean. Hope that helps!

michael_treadwell · Accepted Answer

First, are you sure this IF statement is doing what you want? IF [Enc - MS DRG] >= 765 OR [Enc - MS DRG] <= 795 is going to be true for all numbers. Any real number that you can name is either greater than 765 or less than 795. I think you are looking for an AND statement here if you want to find all numbers between 765 and 795 inclusive. Second, if you are using a filter statement, you don't need to mark things as True or False. The rows flagged TRUE will come out the T output from the tool. The rows flagged FALSE will come out the F output from the tool. ([Enc - MS DRG] >= 765 AND [Enc - MS DRG] <= 795) OR ([Enc - MS DRG] >= 876 AND [Enc - MS DRG] <= 897) OR ([Enc - MS DRG] >= 945 AND [Enc - MS DRG] <= 946) OR ([Enc - MS DRG] >= 949 AND [Enc - MS DRG] <= 950) The statement above should accomplish your goal and everything TRUE will come from the T output on the Filter Tool.

brendafos · Accepted Answer

THANKS!

You are correct on all points.