It was just a observation, no critique of the participants was implied. ... View more

I confirm, the boolean expression in case() works. My problem was the following: To gather one of the needed values to decide on i did the following: | eval no-value-supplied = if(isnull(mkfind(msisdn, "no-value-supplied")), 1, 0) Note that the introduced variable and the constant string in the mkfind are identical. Interesting is: if you output the variable, e.g. via "table no-value-supplied" the value binding is correct (1 or 0 in this case). Using no-value-supplied in a boolean statement inside of case | eval new_var = case(no-value-supplied == 1 AND ....) never yields true. Is this a bug, or did i miss something in the documentation? Renaming the variable fixed the issue. ... View more

The question was not answered (which seems to be the normal): So, is: eval var1 = case(A==0 AND B==1, "ZeroOne", A==1 AND B==0, "OneZero", 1==1, "Neither") Supposed to be a valid construct? In my case i can't get it to work. It's either the default branch (1==1) or NULL. Any hints? Dirk ... View more