Hello everyone, I have a large csv file more than 10 lakhs above rows is there when i read it i am not able to read it properly i got the error which is "Job stopped with an unexpected exit code: 0xE0434352" please help me guys
Welcome to UiPath community
You can split the excel data into some small parts and do you automation
Check out the thread
how to split file in 5 sheet pls help me
Use Read Range activity and set the
Range -> A1:AG200000 Store it as Dt1
Which will give us first set of DataTable and name it as dt1
Have you checked the above thread @zaid.ahmad It will be more detail
@Gokul001 thanks i will try to make this process.
Let us know , If you face any issues @zaid.ahmad
If you are still facing the issue, try using modern Excel activities for read range.
Hello @balraj.krishnappa and @Gokul001
When i merge the data table then i have got an error which is “Merge Data Table: ‘table’ argument cannot be null.
Parameter name: table”
i have followed this thread How to read huge excel in Uipath
This error notify that you are merging the empty Data Table. So cross check the Dt that you has an error have a Data in that Dt.
Like we can split the data and read them
The sequence of activities will be like
— use a Build datatable activity and create a same structure datatable as in excel with same column name and order of columns
and get the output as Finaldt
And followed by this use CLEAR DATATABLE ACTIVITY and mention the input as Finaldt
—the inside excel application scope use Read range activity we can set the range like this
Which will give us first set of datatable and name it as dt1 and here in the property panel enable add headers
—then use again a READ RANGE activity and disable the add headers property and mention the range like this
“A1000001” so that it will start from were we left
Where get the output as datatable named dt2
—now use a For each row loop and pass dt2 as input
And inside the loop use Add Datarow activity and mention the ArrayRow as row.ItemArray and datatable as final dt
So all the records from dt2 will now be added to Finaldt
—then finally use MERGE DATATABLE activity where mention the source as dt and destination as Finaldt
So Finaldt will be our datatable with all records from excel
Though it takes the same time or even less than normal excel application scope and read range activity, it will work without any fail or error
Hope this would help you
please explain merge dt line
Can you share the workflow screenshot @zaid.ahmad
Check out the Skeleton of the workflow
HugeExcel.xaml (8.4 KB)
I was using merge dt inside of for each row but its run successfully.
but now can i use filter dt for two column using final_dt
Have you achieve the answer your query Right?
This above one is a new one Right? @zaid.ahmad
yes i followed your workflow and run it completely.
Kindly close this topic by mark as solved. It would be help full for other too.
You can create a new topic for
i use filter dt for two column using final_dt for this query
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.