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
- Store the source file in File Manager.
- Open ETL Builder and create a new flow.
- Add the correct reader for that file type.
- Validate the incoming fields with preview.
- Add filtering, field-management, and expression stages one at a time.
- Use preview after each important stage.
- Attach the writer that matches the intended destination.
- Run the flow manually first.
- Review Runs and Logs before you schedule it.