Advanced-etl-processor
Loop Legacy Action
About
Loop action provides a convenient way of going through the list of values. Values can be entered by the user, loaded from the file or loaded from the database.
Workflow tab
- The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
- It is usually used for debugging and not recommended for production environment.
- It can be globally disabled using options dialogue
Advanced tab
Values tab
Using file as source for loop
Note: The multiple variables option works with both file and database source. When checked the first line of the file is treated as a list of variables and for the database source the field names treated as variables. When not checked the file line is assigned to the loop variable and for the database the first field is assigned to the loop variable
Loop file example (Multiple variables checked)
<ID>,<Name>,<Email>
1,John,John@someserver.com
2,Peter,Peter@someserver.com
Note: When “Use # for variables names” is checked variable names will look like this: #ID#,#Name#,#Email#
Loop file example (Multiple variables not checked)
John@someserver.com
Peter@someserver.comUsing database as source for loop
After execution tab
Specifies which variables will be set once action execution is completed
Example
Video Tutorial
We have more videos on ETL-Tools.com YouTube Channel,
Please take a look and subscribe to stay updated with the latest content.
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum