I would like to automate an export of a csv file generated from a workflow to a folder in my computer hard drive. I’ve already created the data loading activity and exported into my computer, however to avoid to export it manually every day I would like to automate that task, I don’t how to set up the transfer file activity.
Can someone please explain me how to do it ?
is there’s another way to do this I am also open to suggestions.
You can use 'Data Extraction' activity to create and export files automatically on SFTP. If you don't have access to SFTP then there is one a way to access the exported file, which is to send it to yourself as an attachment of an email delivery(if file doesn't contain sensitive data). It is always better and best practice to have an SFTP access if you want to access files, and avoid accessing files over email.