How to convert any file to any Format

Overview

This Flow extracts data from a file, transforms it, and creates a new file.

Process

In Connections

Read about Connections here.

Step 1. Create source Connection for the file storage. Test it if possible.

• Amazon S3 
• Google Cloud Storage 
• Microsoft Azure Storage 
• Server Storage 
• FTP 
• FTPS 
• SFTP 
• Box
• Dropbox
• Google Drive
• OneDrive for Business
• SharePoint
• WebDAV 
• Inbound email 
• Outbound email 

Step 2. Create a destination Connection for the file storage and test it if possible.

Step 3. Create a Format for the source file, such as CSV Format.

Step 4. Create a Format for the destination file.

In Explorer (optionally)

Access the Etlworks Explorer here.

If source or destination files are nested, learn how to work with nested datasets.

In Flows

Access Flows here.

Step 5. Create a new File to file Flow.

Step 6. Add the new transformation and select FROM Connection, Format, and file and TO Connection, Format, and file.

Step 7. Click MAPPING and configure Source SQL if needed.

Step 8. Test the transformation. 

Step 9. Add per-field Mapping if needed.

Step 10. If you entered a wildcard filename in FROM, enable processing of all files which match the wildcard.

Step 11. Save the Flow and execute it manually.

In Schedules

Step 12. Schedule the Flow to be executed periodically.