How to create a comparison between multiple excel files

Hi! I'm pretty new to Alteryx but I'm trying to learn it for my own sake and whatnot.

I'm coming across an issue in regards to comparing multiple excel files.

I'll attach some pictures here.

Basically there's two files the first one is a master sheet, it has everyone's correct headphone ID, name and everything

The second one has a typo.

I want to create a workspace where Alteryx can find that discrepency and potentially fix it?

Would really appreciate some help! Thanks so much!

Datasets

Help

Accepted answers

Qiu

@lukemanderson12
I have updated the workflow. Guess I deserve that Accept now😁

lukemanderson12.yxmd

Qiu

@lukemanderson12
I manage to output a list that gives the status and result for each employee.

lukemanderson12.yxmd

All comments

lukemanderson12

Also, another one, can alteryx find if someone submits someone elses Computer ID?

as in John Doe writes in Jane Doe's Computer ID and Jane Doe writes in Jane Doe's Computer ID??

Qiu

@lukemanderson12
I use Join and Formula Toos to do the comparing. See if this is you need.

lukemanderson12.yxmd

Qiu

@lukemanderson12
if you want to compare Computer ID, just use Computer ID as the key for Join.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317