I read csv to datatable and scattered to many other dt by loop for each row and many if and Add data row ,but it is to slow. I have of about 18k rows. And robot spent almost an hour with tihis work.
it might be easier and faster to use .net, then invoke code in uipath.
If it is working with CSV or Excel file only, you can perform in Python and invoke python code from UiPath if needed.
thanks very much, can you write some code example
i have data from csv in variable dtAll
and i a have loop for every row. Some first rows i save in firstdt if i have blank value i save rows to secontdt and if i have another blanks row i save rows to thirddt…etc.
so i need pythone code and activity where i can replace this loop