Comparers
Comparer functions play a crucial role in data processing, providing a means to evaluate and establish relative order or determine equality. Take, for instance, the strings Hello, hello, and HELLO. You might question if they are identical. However, it’s comparer functions that can dictate the rules – such as case sensitivity – for how strings are interpreted and compared.
The role of comparer functions is to provide a method to compare values and determine their relative order or equality. Comparer functions are used in various scenarios, such as sorting or performing comparisons, for example, in conditional expressions.
In Power Query, these functions are mostly used as optional arguments to higher-order functions that require a comparison or equation operation. Some of them are listed here, but there are more functions equipped with a comparer or equationCriteria or comparisonCriteria parameter:
|
Text... |
