I have 2 excel files with 315 rows in each file, performing Find and replace or JOIN operation. Now i need to calculate what %age of input rows got matched and unmatched.
Solved! Go to Solution.
Hey @MahanteshS
If you use the join tool, the values that come out of your left and right outputs are the values that are unmatched and value out of the J output are matched. Knowing this you can do simple counts of the records to calculate the % matched.