Hi, my UiPath crashes every time I run this workflow:
Read from several Excel files in folder
From every Excel file, read every sheet and collate together all sheets
Collate together from all files (sheets may have additional columns, append column if present)
Evaluate combined file per row, checking validity of email, contact details etc
Checking for duplicate rows this takes a lot of time because every pair of rows has to be compared, the actual content per row may be different but it can be considered a duplicate because I need to compare content of first name, last name, email, company etc
Building reverse referencing for duplicate rows e.g. if rows 1 and 5 are duplicates, row 5 also has to refer back to 1
Appending error column
Appending duplicate column
Highlighting rows with errors and duplicates
Even if I work with just two files I get about 30 columns and 120 rows and while running the workflow UiPath Studio crashes… UiPath Robot continues executing but does not reach up to the point where it highlights the errors and duplicates…
I don’t want to remove duplicates, just mark them for review. Also, definition of “duplicate” here is not that both rows have exact same content. Need to compare first name, last name and sometimes the data has the full name in the first name field, “John Smith” vs “Smith John” etc. Also check if both rows have email and company, or one or the other or both has email or company missing and then based on the available information decide whether it the row is referring to the same person. The rest of the information can differ
I notice that Write Line activities produce tens of thousands of output log entries as the workflow runs, could this be causing it to crash?
Anil_G
ashokkarale
naveen.s
lrtetala
Yoichi
Youri98
Josh_James
pratik.santani
juan.ramirez1
dheephiga.am