Read From Csv File Step

Brief description

This step reads data from a CSV file and loads it into a DataTable variable. It allows defining a custom delimiter, handling header rows, and specifying how many columns should be imported from the file. If no specific number of columns is set, all columns from the CSV file will be read automatically.

Step Information

Step name (Not required) – the custom name of the process step that labels the editor’s process step box

Input parameters

• CSV file path (Required) – specifies the full path to the CSV file that will be read.
• File has header row (Required) – indicates whether the first row of the CSV file contains column headers:
  • T (true) – the first row is treated as column headers.
  • F (false- default value)
• Delimiter (Required) – defines the character used to separate values in the CSV file (e.g., comma ,, semicolon ;, tab \t, etc.).

Output parameters

• Result DataTable (Required) – specifies the name of the new DataTable variable where the CSV data will be stored. You can define the number of columns to be created in the DataTable. If the number of columns is specified, only that number of columns will be read from the CSV file. If left empty, all columns from the CSV file will be imported automatically.
• Column count (Not required) – specifies the variable that stores the number of columns read from the CSV file.
• Row count (Not required) – specifies the variable that stores the number of rows read from the CSV file.

Additional comments

This step is used to load CSV file data into a structured DataTable format for further manipulation or processing. When creating the Result DataTable, you can define the number of columns and their names manually. If more columns exist in the CSV file than defined in the DataTable, only the specified number of columns will be imported; the remaining columns will be ignored. If the column configuration is left blank, the entire CSV file is read and all available columns are imported.