How to create a comparison between multiple excel files
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@lukemanderson12
I use Join and Formula Toos to do the comparing. See if this is you need.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@lukemanderson12
if you want to compare Computer ID, just use Computer ID as the key for Join.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@lukemanderson12
I have updated the workflow. Guess I deserve that Accept now😁
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@lukemanderson12
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@lukemanderson12
I manage to output a list that gives the status and result for each employee.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So great! Thanks so much!