How are NULLâs considered? I have a case statement which gives the right value matching measure -used debug to test. But when it comes to matching rules, it skips the rule.Â
Example:
Name   NPI
Ramona 12345678
NULLÂ Â Â Â 12345678
the 2nd row should match the 1st on NPI value and considering on of them is null.
Even the scenario
Name   NPI
NULLÂ Â Â Â 12345678
NULLÂ Â Â Â 12345678
these two should match together based on NPI. I do not see a special character. If I replace NULL with a value âAâ , they match with rule Matching on NPI. but does not work for NULL.Â
Â
Any thoughts or suggestions appreciated.Â
Best answer by AKislyakov
View original