inner keep

[Anonymous]

Hi,

I am trying to reduce loads by using INNER KEEP (<table>).

(Inner joins  which reduce number of rows loaded for subsequent tables).

Tried all kind of syntax combinations, but its not working.

Please note that I am loading from SQL, not qvd.

Thanks

[Anonymous]

Hi,

I did exactly that. Not getting an error, just the whole table loads, which I want to avoid.

J

[Anonymous]

That is working, but its slow.

[#4]

Can you post your script or Qlikview file?

[Anonymous]

Ok.

I will do it a little later, because its loading now.. (30 minutes)

[Anonymous · Accepted solution]

This works, but its slow.  (the INNER KEEP is not needed)

Table1:

LOAD Account AS PatientAccountID,

     PatientClass,

     ADDate,

     Discharged,

     LOS,

     Provider,

     PrimaryDX,

     PrimaryProcedure,

     ECD,

     NerveBlock,

     FPxDate

     

FROM

$(vPathName)xxxxyyyyy.xls

(biff, embedded labels, table is KWMatch$);





Table2:

INNER KEEP (Table1)

LOAD   [PatientAccountID]

      ,[ObjectID] AS PatientVisitOID

      ,[VisitDSC]

      ,[StartDTS]

      ,[StartDTS] AS VisitDate

       ,[EndDTS]

       ,[VisitTypeCD]

      ,[CategoryDSC]

      ,[FinancialClassCD]

      ,[UnitContactedNM]

      ,[DischargeDispositionDSC]

      ,[AccommodationTypeCD]

      ,[DischargeToDSC]

      ,[AdmitReasonCD]

      ,[PreVisitDTS]

      ,[AdmitSourceDSC]

      ,[EDWLastModifiedDTS]

WHERE Exists(PatientAccountID);



      SQL SELECT *

FROM SQL.DBO.zzzzzz
where [IsDeletedFLG] = 0 and DatePart(Year, [StartDTS]) = 2014

order by ObjectID DESC;