Automate with ETL

Example Flow from File to Managed Output

A practical ETL example that starts from a reusable uploaded file, validates the preview stage by stage, and writes the result to an operational destination.

Updated 2026-05-1514 minutes read
Before you begin
  • Source file available in File Manager

This is the practical ETL pattern many users need first: start from a reusable file, transform it safely, and write the result somewhere operational.

Example sequence

  1. Store the source file in File Manager.
  2. Open ETL Builder and create a new flow.
  3. Add the correct reader for that file type.
  4. Validate the incoming fields with preview.
  5. Add filtering, field-management, and expression stages one at a time.
  6. Use preview after each important stage.
  7. Attach the writer that matches the intended destination.
  8. Run the flow manually first.
  9. Review Runs and Logs before you schedule it.
Was this page helpful?