Filtering is not happening in the load script

[#1]

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

[Miguel_Angel_Baeyens · Accepted solution]

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

[#3]

Thanks a Ton Miguel. Now its working