Managed File Transfer User Guide

10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Example 2: Printing the Values of a RowSet Variable Using a Loop

It is sometimes useful to troubleshoot Projects by using the Print task to print the values from a RowSet variable to the Job Log. This is accomplished by adding a Print task within a For-Each Loop. Follow the steps below to print out the contents of a RowSet variable generated from a Read CSV task:

From within the Project Designer page, expand the Data Translation folder in the Component Library, and then drag the Read CSV task to the Project Outline.

On the Basic tab of the Read CSV task, specify values for the Read CSV Task attributes:

Input File: The file path and file name of a single file from which to read the data.
Output Row: Set VariableThe name of a variable which will contain the data read from the specified input file.

From within the Project Designer page, expand the Loops folder in the Component Library, and then drag the For-Each Loop task to the Project Outline.

On the Basic tab of the For-Each Loop task, specify the values for the following attributes:

Items Variable: Specify the RowSet variable that contains the items to iterate over.
Current Items Variable: Specify a variable name which will be populated with the value of the row at the current index.

From within the Project Designer page, expand the Miscellaneous folder in the Component Library, and then drag the Print task to the Project Outline.

On the Basic tab of the Print task, specify the Text value.

Text: Using the Current Items Variable, enter the values for the RowSet columns using the Column Index Numbers.

Click the

Save

button, and then click the

Execute Project

button. The Project will iterate through each Row in the RowSet and print the values from each column to the Job Log.

Once the Project has executed, click the

View Job Log

button.

The Job Log will display the results of the Print task for each row in the RowSet variable (which is highlighted in the page shot below).

Rename Saved Search

Table of Contents

Managed File Transfer User Guide

Managed File Transfer User Guide

Example 2: Printing the Values of a RowSet Variable Using a Loop

Example 2: Printing the Values of a RowSet Variable Using a Loop