Skip to main content
  • EN

Hi FME Community,

I've recently been given quite a big task of migrating, renaming and sorting documents. I have naied the moving and renaming part by using a mix of FME and SystemCaller for Robocopy (as FME would output the PDF files as folders, for some reason).

 

So, the moving is all good, but is there a way I can use FME (as I am quite constrained by my working environment, such as python being stock and FME version) to say -

 

"if a file exists in folder A, but also exists in subfolder X, delete the file in folder A"

 

I've tried with a DuplicateFilter, which gets a few, but misses others (attached screenshot).

 

Been going mad with this one

Hi @joe.fme​ ,

 

What are you sorting by? I tested this by sorting by path_directory in descending alphabetical order which always sends the duplicate files from the main folder to the duplicate output port and the file from the subfolder to the unique output port.

 

Or could subfolder X be in a completely different path?

2021-02-12_14-51-11

Good morning Chris, been waiting all weekend to log back on and try this, so thank you for replying!

I was sorting by path_filename - hence the need for a tester to differentiate between file and folder. I see in yours it is path_directory as well as having the filter on for path as *.* which is something I didn't have!

 

As for what to do with the end results, instead of deleting them, I opted to move them into a duplicates folder, which may be more of a nod towards how I was feeling with this work, as I wasn't sure it would do the right thing. Due to this, I've added to your model, a systemcaller that moves them to a folder just in case it's incorrect - but looking at the numbers, my one found 26 duplicates, and yours found 205.

 

Thank you for your help! Means a lot as this was something that's been driving me up the wall for some time

Reply


Community Stats

30,184
Posts
114,569
Replies
37,846
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.