This Flow extracts data from a file, transforms it, and creates a new file.
Convert a file to any Format
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
- Google Drive
- OneDrive for Business
- 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.
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.
Step 12. Schedule the Flow to be executed periodically.