Advanced ETL Processor Automation Tutorials
Plug-in automation examples for file operations, Excel processing, XML conversion, data validation, email workflows, pivots, and scheduled ETL work.
Most of these examples were created as answers to customer questions: move files, process Excel, convert XML, validate data, send emails, and keep logs. Start with one small working example, then add error handling before the job discovers 2:13 a.m. and develops a personality.
Automation tutorial library
Search by task, file type, product feature, or problem.
Showing 30 tutorials
0000 How to Validate and Transform data
Clean a delimited file, validate the year, remove extra spaces, and fix text casing before writing the corrected output.
0002 Automate Downloading IP Location's data file
Download an IP location database, set token variables, and prepare the file for range lookup inside an ETL package.
0003 Replace LF character with space within the file
Replace line-feed characters inside files with spaces when source text arrives with breaks in the wrong places.
0004 How to read a single excel cell value
Read one Excel cell into a variable and use it in an email, useful for totals, status values, and small control checks.
0001 How to rename the file using the date as part of the filename
Rename files automatically with the current date in the filename, so yesterday's export does not pretend to be today's file.
0006 How to Transform a Complex XML file
Handle XML where tag order or extra elements may change, using XSLT to keep the output structure consistent.
0005 How to Transform a Simple XML file
Convert a simple, predictable XML file into a delimited output file without turning the job into an XML archaeology project.
0007 How to Convert XML Attributes into Elements
Convert XML attribute values into regular elements so the data is easier to read, map, and load downstream.
0008 How to Convert XML into CSV
Convert multiple XML files into CSV output using XSLT, with a simple pattern you can adapt for real source folders.
0009 Running ETL workflows from third party software
Trigger ETL workflows from another application by adding work to the queue table through stored procedures.
0010 How to Convert XML into Delimited File
Use an XSLT package action to convert XML into a delimited file when a full transformation is more machinery than needed.
0011 How to Convert Hyper into QVD File
Read a Tableau Hyper file and write a Qlik QVD file, keeping the conversion inside a repeatable ETL workflow.
0012 How to Cleanse the data
Fix common data quality problems: missing values, inconsistent codes, bad dates, stray spaces, and duplicate keys.
0013 Automatically Update Windows Firewall Rules
Read failed SFTP login events, extract IP addresses, and run a PowerShell step to update Windows Firewall rules.
0014 How to strip non-numeric characters automatically
Strip non-numeric characters from fields that should contain numbers, because '$1,234.00' is not always welcome in a database.
0015 Skip duplicated values
Skip duplicate values during transformation using previous-value logic, useful when repeated rows keep arriving uninvited.
0016 Dynamically create excel file based on field value
Create separate Excel files from source data by using a field value as part of the output filename.
0017 Delete sheet from excel files in directory
Loop through Excel files in a folder and delete a named sheet from each file without opening them manually.
0018 Compare two files
Compare two files as part of a package so the workflow can react when content changes or does not match.
0019 Compare two values
Compare two values in a workflow and branch the process based on the result, without adding a custom script.
0020 How to remove spaces from file name
Remove spaces from filenames automatically before the next system complains about them like it has never seen a file before.
0021 Replace values in all fields
Replace values across every field in a dataset when the same cleanup rule must apply to the whole row.
0022 Loading data from files with different fields' order
Load files where columns arrive in different orders, using field names instead of trusting position like an optimist.
0023 Filling the gaps in Excel file
Fill blank cells in Excel-style data so grouped rows keep the values needed for loading and reporting.
0025 Merge Header and Lines file
Merge header and line files into one usable dataset when source systems split related records into separate files.
0024 Performing Mail Merge
Build a mail merge workflow from source data, templates, and email actions for repeat customer or report messages.
0026 Insert records into the file
Insert extra records into an output file as part of the workflow, useful for headers, control rows, or fixed lines.
0086 How to embed picture into email
Embed an image into an automated email message instead of sending another plain notification nobody wants to read.
0087 Pivoting data Using ETL Tools
Pivot source data inside an ETL workflow so repeated values become report-ready columns.
0088 Dynamic Pivot
Create a dynamic pivot when the column values are not fixed in advance and the source file keeps changing its mind.
No tutorials match your search.
Build production automation after the example works
Use these examples as starting points, then add logging, validation, error handling, and scheduling in Advanced ETL Processor Enterprise. The video tutorials and WIKI cover the current workflow features in more detail.