In using the email connector, we felt that a dynamic built-in functionality that would replace existing records based on an ID or date would be of great assistance.
In Summary, we are looking to see if there is a way to set up the connector to replace existing data with new files. So for example, say I load an initial file with date from 1/1 to 1/30. Then the 2nd file has data from 1/1 to 2/28. I'd like the 2nd file to overwrite what is already loaded in there. I want to be able to either replace the first one or replace part of the data loaded based on the date. Right now it's stacking all the data on top of each other creating duplicates in the table each time a new file is sent.
Let us know your thoughts.