Quite often it necessary to go through the list of values and perform specific action for example load files form 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 previous step

Looping through list of files

<Loop Value>  holds current file name

Copy File

Download Free Trial Learn More About Our ETL Software

We have 413 guests and no members online