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.
I am imagining your real example is a little more complicated than this. I do not think there is currently a functionality in Alteryx that does exactly this. I would recommend flagging before you filter. For instance you could use a formula tool to create a Rejection reason Column something like.
IF [Fruit] = 'pears' THEN 'Fruit Contains "Pears"' ELSEIF [Fruit] = 'grapes' THEN 'Fruit Contains "grapes"' ELSE Null() ENDIF
So, if I have multiple filter conditions for multiple fields do I need to create so many dummy fields as you mentioned? Is there any way I can get the information from the Filter TOOL about which record came to False on what condition?