How to only show rows that share data in same field?

Question

I'm totally stumped on how to only show rows from two reports that share the same value in a field. I apologize in advance if I am using incorrect Alteryx lingo.

For example, I have two separate filter results, A & B from the same data set that share the same exact columns (name, purchase date, amount). I only want to show rows from both A & B that share the same purchase date. I'm thinking the Join tool is the correct tool for the result that I want but the data I'm seeing isn't what I'm expecting and now I'm not so sure I can even join two results from the filter tool.

AbhilashR · Answer

Hi @DataNewB, one way to approach this problem statement could be to count the records that have duplicate dates and join the data back to itself. I have included a sample solution to help visualize my approach:

sample.yxmd

DataNewB · Answer

Thank you for replying!

I only want the records that share only the date and not anything else so if I joined all three fields, wouldn't the join report show matches for all three fields?

Emil_Kos · Answer

Hi @DataNewB,

if I understood you correctly then the join tool is the one that you should use.

Please join the data using all relevant columns.

In this case pick name, purchase date, amount and it should start to work.