Forum Discussion
Power Query to Match Bank vs OR amounts within each Branch
Hello mbuhary
this is what i meant when I asked you about what happens when 2 rows are found. Keep only one and keep the other one for matching to other...
but in such a scenario it all would depend what row is processed first... so depending on your sort order there would be different outcomes. I don't think that would in your interested. The solution I provided is a kind of fuzzy join where a row of table B can suit multiple (or none) rows from table A.
For the result your are asking for I have no solution right away and this behavior was not specified in your initial request.
How important is this for you having this? Is this a one time shot or a daily process? How big is your database?
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
I am sorry if I have not made it clear enough earlier.
But the one to one match is very important for us.
And the data is processed at the moment manually on a monthly basis.
Each month's data can accumulate up to 20,000 to 30,000 rows on average.