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).