Forum Discussion
Solved
Import files filtered by preferences
Good morning, I have a car history with the model, registration and status of each car. But, some people access to this file and edit it. When I try to cross-reference this file with another fil...
Hello alejandroezp ,
It depends on why they are still there. In my opinion, it is because the data must follow a different scenario than the one initially mentioned.
Have a nice day,
Vivien
- Import both files (Excel, I imagine)
- Merge the queries into a new one
- Choose the join keys
- You get a third query result
- Sort by the status column so that the garage status is at the top
- Select the key columns from which you want to remove duplicates
- Right-click -> Remove duplicates
Feel free to give it a kudo and mark it as the solution if it suits you.
Have a nice day,
Vivien
Good morning,
I've tried removing duplicates, and it's worked in most cases. But there's a small group that hasn't been affected by this and is still showing up incorrectly. What could be happening in these cases?
Regards, and thank you very much for all the help.
Hello alejandroezp ,
It depends on why they are still there. In my opinion, it is because the data must follow a different scenario than the one initially mentioned.
Have a nice day,
Vivien