This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello. New to Altryx. Tried Googling and can't seem to find a good answer. I am trying to create a filter based on if the Bool value in two different columns is True. I have tried multiple formulas, but I still don't ever return any results (and yes, looking at the raw file, there are True-True combinations). Ultimately I want to only keep the rows where I have True in both of the columns. I already changed the dtype from V_String to Bool. Below I am creating a new column called Scenario1 as my output and am attempting to assign "keep" or "delete" based on if both bools = True (so, "keep" if bool-bool = true-true and "delete" for all other bool-bool combinations)
IF ([Anchor] = 1 && [Band] = 1) THEN "Keep" ELSE "delete" ENDIF