How to create a comparison between multiple excel files

[lukemanderson12]

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!

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

[Qiu]

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

[lukemanderson12]

I'm not sure I understand. I took your last example and it works amazing thanks!

Say someone entered someone else's Computer ID, how would I be able to check for that?

[Qiu · Accepted solution]

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

[Qiu]

@lukemanderson12 
Thank you.

[lukemanderson12]

Another question if you're willing.

I've now isolated the fact that I have the correct Computer Numbers and the correct headset for each employee.

Employees can have multiple headsets and I want to be able to populate all headsets attributable for each employee and also check if the employee submitted the correct headset and the correct computer number against the master list. How would I be able to do that? I.e. if the employee submitted the wrong headset but the correct computer number how could I detect this?

Thanks in advance, sorry if the questions a little malworded.

[Qiu · Accepted solution]

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

[lukemanderson12]

So great! Thanks so much!