Regarding comparision between two qvds

Thu, 02 Jun 2011 17:30:30 GMT

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

Re: Regarding comparision between two qvds

Fri, 03 Jun 2011 03:52:48 GMT

Plz find the attachment....

Hope it solves ur purpose...

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

AA:

LOAD * INLINE [

MPN

];

BB:

LOAD * INLINE [

MPN1

];

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.