Hi,
I have a process where I add an excel spreadsheet to a collection (C1). The spreadsheet contains a list of file names. I then create another collection (C2) that contains all file data from a specific directory.
Then, I have a nested loop that loops through both collections on the file name. If a file name from C2 matches a file name from C1 that file is moved to another directory. Everything works brilliantly. However, recently I encountered a situation where I had 200 file names in C1 and 600 files in C2. The loop took forever to run.
Any suggestions on a more efficient way to handle this?
View attachment bp-example.png
I have a process where I add an excel spreadsheet to a collection (C1). The spreadsheet contains a list of file names. I then create another collection (C2) that contains all file data from a specific directory.
Then, I have a nested loop that loops through both collections on the file name. If a file name from C2 matches a file name from C1 that file is moved to another directory. Everything works brilliantly. However, recently I encountered a situation where I had 200 file names in C1 and 600 files in C2. The loop took forever to run.
Any suggestions on a more efficient way to handle this?
View attachment bp-example.png