How Import CSV file and load into CDT(without database)

You could try using https://community.appian.com/b/appmarket/posts/text-file-reader. Basically load the csv file, split it into an array based on carriage return.

a!localVariables(
  local!items: split(
    readtextfromfile(cons!S_CSV_DOCUMENT, true),
    char(10)
  ),
  a!forEach(
    items: local!items,
    expression: split(fv!item, ",")
  )
)

Mathieu Drouin said:

Basically load the csv file, split it into an array based on carriage return.

And pray none of the data columns contain escaped commas... (though the parse CSV row function might help with this, otherwise it'll be a nightmare)

Mathieu Drouin said:

Basically load the csv file, split it into an array based on carriage return.

And pray none of the data columns contain escaped commas... (though the parse CSV row function might help with this, otherwise it'll be a nightmare)