Scattered dt from csv to many other dt

Help Activities
, , ,
1

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.

2

it might be easier and faster to use .net, then invoke code in uipath.

3

If it is working with CSV or Excel file only, you can perform in Python and invoke python code from UiPath if needed.

4

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

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.