I have a text file with over 2million rows that I need to convert to csv. When opened in Excel, it cannot hold more than around 1 million rows so users always get a warning saying that not the whole file downloaded.
I read a text file to string, Generate data table off the back of that string, and then I need to write the data table to a csv file.
How can I specify in Uipath to write a separate csv for every 1million rows in a data table please?
Many thanks for your help,