Regarding comparision between two qvds

[#1]

Hi Everyone Special,

I have a new problem at which I am stuck at the moment.

A. I have a field called MPN in two  separate qvds- say qvd A and qvd B. MPN holds product number.

Over the period there are many product which gets cancelled.

QVD A stores the history and the QVD B stores the current records.

So there are cases in which MPN has product numbers in QVD A but as the product got cancelled so the MPN field in QVD B won't be having

any of those product number. The requirement calls them deleted items.

Now the task is to find how many of such product number got deleted over the period.

Thanks beforehand and I really appreciate your time and effort,

Bikash

[#2]

Plz find the attachment....

Hope it solves ur purpose...

if u can't open the file then refer this:

AA:

LOAD * INLINE [

    MPN

    1

    2

    3

    4

    5

];

BB:

LOAD * INLINE [

    MPN1

    3

    4

    5

];

CC:

Load

MPN1,

MPN1 as MPN

resident BB;

drop table BB;

In front End:

To count deleted items:

=

count(if(MPN<>MPN1,MPN))

To find deleted Items:

=if(MPN<>MPN1,MPN)  in list box.