Remove matched rows from input file to generate new output file

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!

Sample IN 2.xlsx

Sample IN 1.xlsx

Workflow

Input

Parse

Macros

Fuzzy Match

Dynamic Processing

Join

Interface Tools

Data Investigation

Iterative Macro

Accepted answers

DataNath

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.

Remove matched records.yxzp

All comments

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?

Workflow sample.yxmd

DataNath

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.

Remove matched records.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703