Hi.
I am attempting to merge 2 Excel files with a large amount of data, and I'm struggling to find an efficient way to merge them automatically using a flow (Preferably using PAD), so I'm hoping someone here has a good idea on how I can speed up the process.
The data amount is pretty big, File A contains 35.152 rows of data, and File B contains 10.373 rows.
What I'm trying to achieve is merge data for each row from File B Column 6 if File A Column 1 = File B Column 1.
I can easily reiterate through the data using a loop and read through each row of File A, compare with File B and then populate File A if match. But this takes approximately 1 minute pr. 100 rows, resulting in a very long runtime. Its mostly the write process that takes time, since the whole compare process is sped up considerably by using the "Find and replace"-action.
So is there a more efficient way to automate a task like this? Essentially, what we need is a VLOOKUP type process.
Any tips is very welcome!
