BusinessObjects Board

Null values in Firm Names - Match Transform

Hi,
I am stuck with this problem in Match transform. I have a requirement where the one firm’s name (master record) has to be compared with multiple other names in a location. In case the master record has a null value, it still has to be compared with other records and a ‘0’ match score has to be returned. But when it is null, Data Services seems to ignore this record and considers some other record as the Master record (M) and returns the match scores, even though the data has been sorted to set the master record as the first record.

Has anybody faced this situation or has a solution to resolve this???

Thanks in advance.


moheesh (BOB member since 2012-11-06)