Quite often it necessary to go through the list of values and perform a specific action for example load files from the directory and process them one by one.

In the latest version of Advanced ETL Processor and Visual Importer ETL, we added Loop Action.

Now it is possible to loop through the list of values

    1. loaded from the text file
    2. Database
    3. Entered by the user
    4. Numeric values "From To" and "Down To"

Example:

Looping through the list of the files:

Loop1

Saving list of files into the file

Creating List of files

Looping through the list of files created at the previous step

Looping through list of files

<Loop Value>  holds current filename

Copy File

Download Free Trial of Advanced ETL Processor
Direct link, no registration required.