Filtering is not happening in the load script

Mon, 05 Aug 2013 13:36:58 GMT

The below one is my excel source data. I want to extract only the incremental data which is above 27/08/2013, in that case only 2 records (28/08/2013) to be extracted whereas my load script extracts all the records from this source file. Please refer my load script below

CustID	CustName	Location	Last_upd
10	Ashok	Chennai	27/08/2013
20	Madhu	Mumbai	28/08/2013
30	Shankar	Mumbai	27/08/2013
40	Jane	Bangalore	28/08/2013
10	Ashok	Chennai	26/08/2013

Let vMD=peek('Last_upd',-1,'Obt_maxdt');

Trace $(vMD) -- ( this one shows 27/08/2013)

Delta:

LOAD CustID,

CustName,

Location,

Last_upd

FROM

E:\Downloads\Customer.xlsx

(ooxml, embedded labels, table is Delta)

where Last_upd > $(vMD);

As per the value stored in $(vMD) the above Load script should extract only the records greater than 27/08/2013 whereas it fetches all the 5 records and store it in a qvd file. ??/ Not sure , why is that fetching all the records instead of fetching only 2 records ??

Can someone help me to find out where am making mistake here..

Thanks

Joe

Re: Filtering is not happening in the load script

Miguel_Angel_Baeyens — Mon, 05 Aug 2013 13:43:52 GMT

Hello Joe,

Since the date is a literal value here, try instead:

where Last_upd > '$(vMD)'; // using single quotes

And make sure the contents in vMD has the same format that the values stored into field "Last_upd"

Hope that helps.

Miguel

Re: Filtering is not happening in the load script

Mon, 05 Aug 2013 13:50:25 GMT

Thanks a Ton Miguel. Now its working

topic Re: Filtering is not happening in the load script in QlikView

Filtering is not happening in the load script

Re: Filtering is not happening in the load script

Re: Filtering is not happening in the load script