Is it possible ?

[#1]

Dear all,

I need to filter a big table (Booking infos table/Prenotazioni_Term0) choosing records that match exactly against a master data table (Departments/ Strutture). If Strutture.P2STR = Prenotazioni_Term0.P2STR_STR then the record is Ok otherwise not. The two origin table are .qvd files.

Using a Right Keep over (Departments/ Strutture) I thougth it was enough but I still found a lot of rows with no value and the usual value '-' within all fields.

How can I have a clean result Tablexxx where all data are correctly present without '-' cells values ?

Tablexxx:
RIGHT KEEP (Strutture)
LOAD RESIDENT Prenotazioni_Term0;
P2STR_STR, P2AIP, P2NNP, P2PAR, P2DAP
FROM Strutture.qvd (qvd), Prenotazioni_Term.qvd (qvd
WHERE P2STR = P2STR_STR ;

Please suggest me how to resolve it.

Thanks Giovanni

Is it conceptually wrong ? Which is a possible alternative ?

[Anonymous]

Everything's possible... My preference is to use exists() function:

...
Strutture:
 P2STR,
 ...
FROM Strutture.qvd (qvd);
Tablexxx:
LOAD * FROM Prenotazioni_Term.qvd (qvd)
WHERE exists(P2STR, P2STR_STR)

[#3]

Many Thanks, today I will try it. Bye. Giovanni