Using Read action
Use the Read action to retrieve values from a CSV or TXT file and insert them into a Table variable in order to perform operations with the data values.
Note: The Read action only support CSV/TXT files that conform to the RFC 4180 standard. For more information about the standard, see Common format and MIME type for CSV files.
To retrieve values from a CSV/TXT file, do the following:
- Double-click or drag the Read action from the CSV/TXT node in the Actions palette.
- Enter the name of the session that you have used to open the CSV or text file in the Open action.
Select a Table variable from the Assign value to the
Create a variable if it does not already exist. The Control Room shows a descriptive default variable name. If you create several output variables, subsequent variable names are appended with a -1, -2, -3, and so on to avoid duplication.
Perform operations with the values in the Table variable using the Data Table package.