In this merge query, I also created a full path to each file I wanted to delete by merging the path and file name column as shown below.Īnd I then prepended the DOS command del (including a space) to the front of the file names. Note that I didn’t use date created, as this is the date the file was copied to my PC rather than the date the photo was created on the phone. I did an “inner join”, hence just keeping those that match. I figure if the extension, the date modified, and the size are all the same, then it must be the same image. I did this by selecting 3 columns to match in the merge. The next thing was to merge 2 queries together. I just clicked the expand button (1) and then deselected all the options just keeping size (2 below). The only thing I did that was a bit “non-standard” was to extract the file size from the attributes column. Repeat for each other main folder location. Once the query is created, set the query to “do not load”. Just select, Data\Get Data\From File\From Folder. This is pretty standard Power Query stuff.
Create a query that links to each folder using Power Query for Excel, and set the list to “do not load”.There are some great image management tools out there – I personally love EXIF Tool But I wanted to use Power Query to solve this problem. So the problem is, how could I delete the doubled up files without deleting any photos that were truly different. Apple really doesn’t go out of its way to make it easy, of course. I think this is as a result of me using different software to transfer the photos across from time to time. Unfortunately the names of the files were different in the different locations as can be seen side by side below. Each of the 3 sections below are images from my phone stored in different locations After running the software I noticed that I had stored photos from my phone in a few different places. I use a program called WinDirStat to show me graphically what is taking space (as an aside, this is great software and you can download it here). I was trying to clean up my hard disk drive on my PC the other day. Relationships in Power BI and Power Pivot.Who Needs Power Pivot, Power Query and Power BI Anyway?.
#DUPLICATE PHOTO FINDER BATCH DELETE INSTALL#
The Best Way to Install Power BI Desktop.30 Reasons You Should Be Considering Power BI.Dimensional Modeling (Excel and Power BI).Power BI for the Business Analyst (with live Q&A).
0 kommentar(er)
