Loops

Up Loop Example

The Up Loop Action as a basic loop action which iterates “from” “to” value.

Up Loop Example

Down Loop Example

The Down Loop Action as a basic loop action which iterates “from” down “to” value.

Down Loop Example

File Loop Example

The File Loop Action processes each line of a delimited file, assigning values to variables based on the column names specified in the file header.

File Loop Example

Files Loop Example

The Files Loop Action iterates through the list of files, file name is assigned to #LoopValue# variable.

Files Loop Example

Database Loop Example

The Database Loop Action iterates through database records, assigning values to variables based on the field names.

Database Loop Example

Office 365 Email Loop Example

The Office 365 Email Loop Action iterates through email messages using the Microsoft Graph API, downloading them one at a time. This approach minimizes the load on the email server.

Office 365 Email Loop Example

IMAP4 Email Loop Example

The IMAP4 Email Loop Action iterates through email messages, downloading them one at a time. This approach minimizes the load on the email server.

IMAP4 Email Loop Example

JSON Array Loop Example

The Json Array Loop Action iterates through each value in the JSON array sequentially

JSON Array Loop Example

JSON Object Loop Example

The Json Object Loop Action iterates through each property JSON Object sequentially

JSON Object Loop Example
  1. IMAP4 Email Loop Action
  2. Office 365 Email Loop Action
  3. File Loop Action
  4. Files Loop Action
  5. Database Loop Action
  6. Down Loop Action
  7. Up Loop Action
  8. Json Object Loop Action
  9. Json Array Loop Action

Video Tutorials




For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on May 4, 2025 • 2 min read • 300 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License