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
Hello alejandroezp ,
My advice is not to do this during import, but once you have joined your two files in PowerQuery (after merging the queries).
You then have the option to remove duplicates according to the columns you want. Power Query will keep the first occurrence in the table, so you need to sort the results so that Status Service appears first, and it will remove the row with the status garage.
Feel free to give it a kudo and mark it as the solution if it suits you.
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,
VivienGood 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
- Import both files (Excel, I imagine)