Reading large text file

[ppr (Peter Preuss)]

large datasets can be handled by following:

• Assign Activity: File.ReadAllLines(CSVFilePath).ToList()
• Generate Datatable Activity

have a look here for a case using these main building blocks:

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)