Remove Duplicate Files by Order Number

Post Reply
Mark Casey
Newbie
Posts: 4
Joined: Thu Sep 26, 2019 1:47 pm
Location: Leeds, UK

Remove Duplicate Files by Order Number

Post by Mark Casey » Fri Mar 06, 2020 1:27 pm

HI Guys

I have two (or maybe 3 or 4) xml files arriving in an Automanaged Folder.

I need to allow only one of the files through the Flow if the Order Number of each file is the same, and the others discarded (this is the first 5 digits of the file name)

Any help would be appreciated :D

laurentd
Member
Posts: 36
Joined: Wed Mar 13, 2019 2:06 pm

Re: Remove Duplicate Files by Order Number

Post by laurentd » Wed Jul 08, 2020 1:52 pm

Hi Mark,

Use the Counter - Numberer app https://www.enfocus.com/en/appstore/product/counter
Create a counter for each order number, counter name = [Job.NameProper:Search="\d{5}"]
Sort the jobs on the condition [Job.PrivateData:Key="counter after"] equals 1 -> treat, All other jobs -> discard
 
treat or discard orders.png
treat or discard orders.png (76.79 KiB) Viewed 744 times
Laurent De Wilde, Solution Architect @ Enfocus

Post Reply