I was facing a challenge where I have a collection of data [extracted from .txt file] need to add into a data table. The data row I have to start from column number 35 to n (n = 173 max. rows of data). I have used add data row activity for first 35 rows since they are static value but from there it could be a collection of data i was supposed add from 35th row in the same Datatable.
I was using excel activities but it consuming more time(it taking 5 min to extract for 1 case, i have 7000+ ), so I cant use Excel activity.
Kindly suggests any solution for this. Thanks in advance!!
create datatable with build data table activity then use add data row inside a loop to add static and dynamic values for better performance use write csv or write text file instead of excel this approach is aligned with UiPath best practices for handling large data without excel dependency.
If you found helpful please mark as a solution. Thanks
Happy Automation with UiPath
The Plan coverage is data where I am using for each to extract each coverage payer because, i can get max. 173 coverage plans for a case. So I have to incorporate into Same Datatable after URL (35th row in my Datatable)
Payer Information
Phone Number: 1234354677 URL: uipath.com
Can you share the above as text file because some characters are identified as special character in the forum and it’s not same as original text.
Also can you share expected output as xlsx file etc?
Thank you for sharing. Can you share additional information for rule to map into datatable?
For example, HBPA Coverage Message1.5 (where Alfa; Alfa; Alfa comes from?)
It seems your requirement is a little complicated.
The following will return your expected result from the text (except column name). Can you check this?
