Forum Discussion
Fuzzy match combined excel files
Hi, I'm working on an idea and it will involve combining around 1,000 excel files each with about 5,000 rows. I will then perform fuzzy match in just one column to look up some keywords which will po...
I'm not exactly sure on how you will automate getting 1000 excel files. I guess that PBI will be very slow in getting so many different files. I would consolidate first in a single excel and load that.
Anyway 5 million rows is large but not extremely large for PBI. You can apply your formulas on a fuzzy match with a calculated column.
the files are saved in a SP library, and PBI will be used to combine them and then perform the fuzzy match. How can I apply fuzzy match using calculated columns?