Utilities

Create Object from CSV

csv1
csv2
csv3

Activity converts either a String variable (eg. output from Read Text File), or data from an existing text file into a two-dimensional array. 

Separator requires the character delimiting data fields in your source .csv file, usually either a comma ( , ) or a semicolon ( ; ). 

Include Headers (default: off/False) determines whether the activity will skip the first row of the source data (typically containing column headers) when creating the array. 

Parameter NameParameter TypeIn/OutDescription
Alternative Scenario If FailedBooleanInputcheckbox; default is "on"
Display NameLiteralInputchanges display name of the activity
Exclude from Transaction CheckBooleanInputcheckbox; default is "off"
Include HeadersBooleanInputcheckbox; default is "off"
Content/File PathStringInputinput string or directory path to a file (file name and extension included)
SeparatorStringInputcharacter that separates each field of text in .csv file
Export from FileBooleanInputcheckbox; default is "off"
OutputString[][]Outputvariable to store the retrieved value
ResultBooleanOutputreturns a Boolean value. True if no error in activity, otherwise will return False
Result CodeInt32OutputResult Code will return 0 if there is no error in activity, otherwise in most cases it will return 1, the extended result code will show only in several chosen activities