CSV To List Mapping Step
  • 07 Mar 2024
  • 1 Minute to read
  • Dark
    Light

CSV To List Mapping Step

  • Dark
    Light

Article Summary

Step Details

Introduced in Version---
Last Modified in Version7.12.0
LocationData > 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

PropertyDescriptionData Type
File InputThe CSV or Excel file that is used as input.
FileData

Input Data

PropertyDescriptionData Type
Input File TypeDefines the type of file used as an input to the step. Currently, the options are Csv, Excel_xls, Excel_xlsx and AutoSelect
---
Worksheet IndexDetermines which worksheet that will be evaluated.
Int32
Ignore First LineIf the file has a header row, this property can be toggled to ignore it. Boolean
Ignore Empty RowsIgnores any rows that do not contain any data.
Boolean
CSV DelimiterDetermines which delimiter will be added with the values for CSV files.
---

Outputs

PropertyDescriptionData Type
OUTPUTSList of the Object that the CSV was mapped to.List of ---

Output Data

PropertyDescriptionData Type
Output TypeThe desired Data Structure to map the CSV values to.---

Related Information

Forum Posts:
Using 'CSV To List Mapping' Step


Was this article helpful?