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 new to Alteryx and I am trying to filter using values in the spreadsheet itself.
For example say I have column a and column b, I would like to create an expression that checks whether the field in row 1 column b exists in any of the rows in column A. Is the filter tool the best way to go about this?
- split your flow into 2 - one takes everything (the one going downwards in the screenshot) and the one going straight
- The top one you want to get the unique list of items in column B and it strips out the column A. Reason for this is that you can use this as a filter
- The bottom one then meets with this in a join - you join Column A from the full data with the unique set of Column B values - and then throw away anything where there's a match (if you want to filter - if you want to keep the matches, then take the J channel instead of the R channel from the join).