I am looking for suggestions on how to configure a flow.
The flow I have does the following:
- Pull csv files from FTP (Invoices)
- Does some transformation and lookups
- Does a lookup to see if an Invoice already exists
- Creates Invoice (HTTPS) (input filter based on the result of 3)
The problem is that the duplicate check does not work if the same invoice comes in in two different files in the same run. This is because all the duplicate checks are done before any invoices are created. I am looking for a way to prevent duplicates if the same invoice comes in twice during the same run.
Please sign in to leave a comment.