LearnVBA83
Board Regular
- Joined
- Dec 1, 2016
- Messages
- 112
- Office Version
- 365
- Platform
- Windows
Hi experts!
I have 3 systems that I am trying to tie out lets call them (Apple, Orange, Grape). Each system has a unique ID that should tie between the systems and I can download the weekly reports in csv or excel format. What I need to do is compare all three systems to see the below results:
What is in Apple but not Orange?
What is in Apple but not Grape?
What is in Orange but not Grape?
What is in Apple and Orange that tie by Unique ID but have a variance in original cost?
What is in Orange and Grape that tie by Unique ID but have a variance in original cost?
What is in Apple and Orange that tie by Unique ID but have a variance in payment amount?
What is in Orange and Grape that tie by Unique ID but have a variance in payment amount?
What is in Apple and Orange that tie by Unique ID but have a variance in adjustment amount?
What is in Orange and Grape that tie by Unique ID but have a variance in adjustment amount?
I would like for this to spit out the results in separate spreadsheets.
What system would you use? I would love to use Alteryx but I don't think my boss would spend the licensing fee. Systems on my computer are Excel, Access, I think power query in excel, I think i have power BI. Any ideas?
I have 3 systems that I am trying to tie out lets call them (Apple, Orange, Grape). Each system has a unique ID that should tie between the systems and I can download the weekly reports in csv or excel format. What I need to do is compare all three systems to see the below results:
What is in Apple but not Orange?
What is in Apple but not Grape?
What is in Orange but not Grape?
What is in Apple and Orange that tie by Unique ID but have a variance in original cost?
What is in Orange and Grape that tie by Unique ID but have a variance in original cost?
What is in Apple and Orange that tie by Unique ID but have a variance in payment amount?
What is in Orange and Grape that tie by Unique ID but have a variance in payment amount?
What is in Apple and Orange that tie by Unique ID but have a variance in adjustment amount?
What is in Orange and Grape that tie by Unique ID but have a variance in adjustment amount?
I would like for this to spit out the results in separate spreadsheets.
What system would you use? I would love to use Alteryx but I don't think my boss would spend the licensing fee. Systems on my computer are Excel, Access, I think power query in excel, I think i have power BI. Any ideas?