0

I am trying to get a solution for a unique exception case of File drop automation.

The scenario is, a file(with wrong data) is dropped into FTP, overwrites a Data extension and waits for 2 hours and then triggers a journey to send out the emails. During this delay of 2 hours, a new file (with correct data) is dropped into FTP within an hour. Here the 1st file drop automation is in progress while the second one waits in the queue.

Is there a way to stop the email triggering from the 1st automation since it had bad data with any automation activity?

  • What do you mean by “bad data”? – zuzannamj Jan 25 at 11:26
  • Wrong data - the data is in a good format. But just that we don't want to send emails to the data contacts. Bad data in terms of business I can say – CloudDot Jan 25 at 15:02
  • Can you 100% guarantee that a “correct” data file will always come through <2 hours after the “bad” data file; and they always come through in that order (bad, good, bad, good, etc)? Do you have access to the system/processes that send the bad/good data files? Are the bad and good files exactly the same data structure? – Cameron Robert Jan 25 at 20:53
  • @CameronRobert, 2 hours of delay is from the file drop to sending email. – CloudDot Jan 26 at 8:04
  • Hi CloudDot, can you please provide additional detail (questions above). – Cameron Robert Jan 26 at 8:23
0

Assumptions: - Consistent file name & structure - Consistent file drops/timing

Solution: Skip every 2nd file drop. You can setup an Automation Studio activity to trigger/start on file drop to a specified FTP location. In the automation, load the data file and do any data processing and email sends needed. Then set a “wait” activity for 2 hours. This 2 hour wait activity will ensure the automation is still running when the next (bad) data file comes through. If you disable queuing, the automation will skip the command to run again, thus “skipping” every 2nd file that is uploaded.

If you time this correctly, it will achieve your goal of only running/processing every 2nd file.

| improve this answer | |
  • Thank you very much. Will try this solution. – CloudDot Jan 26 at 10:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.