Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
$(qvd_name)
load
[Loan Number],
[Loss Mit Status Code],
[Servicing Sold Id],
[Referral Code]
FROM(qvd) ,'NSM120110'); /*I am only trying to eliminate records having this Servicing Sold ID here. Instead I seem to eliminate far more. When I comment out this line of code I get 4000 records. When I include this code I only get about 147 records. Any ideas why?*/
where
[Loss Mit Status Code] = 'A'
and not Match([Servicing Sold Id]
Try have all the records first and select only these you wont
Select only records selected and count it and compare
It is possible you have any problem with the relation inter files
Saludos,
Enrique Colomer
Actually after some "poking" I found the answer
where [Servicing Sold Id] <>'NSM120110' seemed to work. still a little new at this