Blocking

[dalecooper]

Hi

Another Matching question:

Looks like it is not a good idea to block on null columns?
Example:
MatchColumn1 MatchColumn2
CompName B
CompName
CompName C

The above result will be that no blocking is done.
The only way to get it matched is using the following:
Block on MatchColumn1 and do the matching
on MatchColumn2, Critical missing ok.

Is that correct?
Shouldn't it be possible to block on null values?

Regards
Dale

[JRodriguez]

Dale,

All records containing nulls values in columns that are part of your blocking criteria become residuals, but will be available for next passes where you can have a different blocking criteria using other columns

It is always possible to handle nulls values in any previous step (standardization ?) and default a value for any nulls...

[dalecooper]

Thanks again Julio!

[JRodriguez]

Dale,

All records containing nulls values in columns that are part of your blocking criteria become residuals, but will be available for next passes where you can have a different blocking criteria using other columns

It is always possible to handle nulls values in any previous step (standardization ?) and default a value for any nulls...