Remove matched rows from input file to generate new output file

[Saratnarendran]

Hi all,

I am new to Alteryx and I need to create a workflow that takes two input files (Sample IN 1) and (Sample IN 2). Sample IN 1 has 3 tabs (2 Input tabs and 1 output tab--> Initially output tab has some dummy data (highlighted in yellow)). The workflow should compare the Input tabs of Sample IN 1 with Sample IN 2 and find for match. If records are matched, then those records need to be moved to the output tab (below dummy data) of Sample IN 1. (Note: Records need to be removed from tab 1 & 2, once they are moved to Output tab. That's why they are highlighted). I have attached the corresponding excel file that needs to be turned into a workflow. Please help.

Thanks!

[ChrisTX]

You can use a Join tool.

What have you tried so far?  Do you have a sample workflow?  Are you just stuck, not sure where to start?

If you're just starting, the Learning Paths are a great resource:

Community > Learn > Academy > Learning Paths

https://community.alteryx.com/t5/Learning-Paths/tkb-p/learning-path

Chris

[Saratnarendran]

Hi Chris,

Thank you for the quick response. Actually I have used the Join tool and have a sample workflow as attached. But I have it as two separate outputs. I need those to be combined into the same input file and also remove those matched records from tabs 1 and 2. But, I am stuck at this step. Sorry for not posting the workflow before.

Can you please help?

[DataNath · Accepted solution]

How does this look @Saratnarendran? My only concern is this took a little bit of extra cleanup to remedy some mismatched field names (extra whitespace) and remove null rows.