Using the For each row in CSV/TXT iterator
Use the For each row in CSV/TXT iterator in the Loop action to read the data of each row in a CSV or text file and assign the current row to a record variable. The bot reads the values in each cell as string-type values, even if there are numerical values.
First, open the CSV or text file. Using the Open action for CSV/TXT file
- Double-click or drag the Loop action from the Loop package in the Actions palette.
- Select the For each row in CSV/TXT option from the Iterator list.
- Enter the name of the session that you have used to open the CSV or text file in the Open action.
Select a record variable from the Assign the current row to this
variable list or create a new one.
Note: If you select an existing record variable, ensure that the column headers capitalization in the CSV or text file match that of the schema of the record variable. Schema
For an example, see Build a Bot Insight dashboard bot.