Read CSV file - process running forever

[ppr (Peter Preuss)]

Along the strategies to split the files in samller chinks, give try on readin the csv differently:

Read in the text:
File.ReadAllLines(CSVFilePath).ToList() / File. ReadAllText…
Feed it to a generate datatable activity and parse it as CSV

Reference:

Make second row of datatable to be the header

@VERNON_SHEN doing it with Excel: [grafik] doing it with csv: [grafik] First Assign: File.ReadAllLines(CSVFilePath).ToList() Second Assign: CSVLines.Skip(1).ToList Config Generate DataTable: [grafik] find starter help here: Vernon_Shen.xaml (6.8 KB) CSV as Zip P-2160-003-A.zip (865 Bytes)

Just give try especially on first part and check how much time the file read does need