Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
I did exactly that. Not getting an error, just the whole table loads, which I want to avoid.
J
That is working, but its slow.
Can you post your script or Qlikview file?
Ok.
I will do it a little later, because its loading now.. (30 minutes)
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;