I have an Automation containing a Data Extract and File Transfer that exports the contents of a Data Extension each day.

Is there a way to only export data from the previous day, rather than exporting all of the data in the Data Extension each day?

  • I believe you do have a field with a timestamp in that Data Extension? Mar 17, 2020 at 14:45
  • Yes, it's writing as date/time though, which is causing its own problems Mar 17, 2020 at 14:53

1 Answer 1


You have a source DataExtension i assume (if not it seems weird).

Create a second DataExtension - "Daily Export of XXX".

Create an SQL that dynamically gets the data from the last day from the Source Dataextension and fill the data in the second DataExtension. Will have a condition that looks like (assuming you have a eventDate field that contains the date):


Do a DataExtract to the Safehouse.

Do a DataExtract to convert it to Utf8.

Create a file transfer to the sftp location.

Synchronize your sftp of salesforce or your internal one with salesforce.


  • Thank you. I don't suppose there is a way of doing this without SQL is there? Mar 17, 2020 at 14:40
  • Uhm, i am not sure. That would be the way that i would use because it is stable, flexible and i know sql to achieve it. Mar 17, 2020 at 14:45
  • SQL is indeed needed, @ThomasHockey. This is the only way to isolate the records you want to extract Mar 17, 2020 at 15:38

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .