Forum Discussion
Import files filtered by preferences
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
Good morning vivien57,
I have just trying to do the process like you explain and i have not the results. Can you explain the process?
Greetings and thank you very much
- 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