arodriguezm
Member
Hello,
Im trying to create an automation that reads each element from one column on a file, and search it in another file in another column if that value exists. The idea is to find the elements from one column that are not in the other column.
The problem im having is that this files are huge, around 6000 rows on each. And the process i created to do this is taking over 15 mins to do it.
First i tried reading each value from one file then search that value on the the other file but that took too long. Then i used collections, so i transfer one file to a collection and then i read each element on the Excel file and use the function from the BPA Collection Manipulation "Collection Contains Value" and the process is a lot faster, but its still too long to use.
Do you guys have any suggestions?
As i said, im trying to find the rows in file A that are not in file B. File = Excel.
Thanks.
Im trying to create an automation that reads each element from one column on a file, and search it in another file in another column if that value exists. The idea is to find the elements from one column that are not in the other column.
The problem im having is that this files are huge, around 6000 rows on each. And the process i created to do this is taking over 15 mins to do it.
First i tried reading each value from one file then search that value on the the other file but that took too long. Then i used collections, so i transfer one file to a collection and then i read each element on the Excel file and use the function from the BPA Collection Manipulation "Collection Contains Value" and the process is a lot faster, but its still too long to use.
Do you guys have any suggestions?
As i said, im trying to find the rows in file A that are not in file B. File = Excel.
Thanks.