Step Details | |
| Introduced in Version | --- |
| Last Modified in Version | 7.12.0 |
| Location | Data > Excel & CSV |
The CSV to List mapping component takes an Excel or CSV file and outputs a defined Decisions type. The step includes a custom mapping editor where the input fields can be mapped into the type.
The step can only map in 99 data rows.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| File Input | The CSV or Excel file that is used as input. | FileData |
Input Data
| Property | Description | Data Type |
|---|---|---|
| Input File Type | Defines the type of file used as an input to the step. Currently, the options are Csv, Excel_xls, Excel_xlsx and AutoSelect | --- |
| Worksheet Index | Determines which worksheet that will be evaluated. | Int32 |
| Ignore First Line | If the file has a header row, this property can be toggled to ignore it. | Boolean |
| Ignore Empty Rows | Ignores any rows that do not contain any data. | Boolean |
| CSV Delimiter | Determines which delimiter will be added with the values for CSV files. | --- |
Outputs
| Property | Description | Data Type |
|---|---|---|
| OUTPUTS | List of the Object that the CSV was mapped to. | List of --- |
Output Data
| Property | Description | Data Type |
|---|---|---|
| Output Type | The desired Data Structure to map the CSV values to. | --- |
Related Information
Forum Posts:
Using 'CSV To List Mapping' Step