Perhaps this question has been asked before but I’ve been searching the entire forum and couldn’t find a proper answer to my question.
I’m trying to read a set of data in a csv file with activity “Read CSV”. The data is 4 columns wide and 500000 rows long. The first column is an integer, but it becomes a String when it’s converted to the data table. Parsing it to an integer row by row takes a very long time (15-20 minutes), whereas just reading it with the “Read CSV” activity in itself takes less than a minute.
Is there a way to read the data where the first column becomes an Int32 type straight away? Or otherwise a quick way to convert a String type column to Int32?