Is it possible ?

Sun, 23 Aug 2009 16:04:04 GMT

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 ?

Is it possible ?

Anonymous — Mon, 24 Aug 2009 01:36:51 GMT

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)

Is it possible ?

Mon, 24 Aug 2009 12:51:42 GMT

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

topic Is it possible ? in QlikView

Is it possible ?

Is it possible ?

Is it possible ?