Error message while lodind data on incremental basis

Wed, 09 Feb 2011 17:35:15 GMT

Error message is attached.

Sript is like following:

Directory D:\Pradnya\Data\;

Temp:

Load Max(Date(Trim([Actual Ackowleged Date Time]),'DD/MM/YYYY hh:mm:ss')) as RECORD_DATE

//Load Max([Actual Ackowleged Date Time]) as RECORD_DATE

From

..\Qvd\Ticket_Log.qvd

(Qvd);

Let vReloadDate = Peek('RECORD_DATE');

//Let vReloadDate = NUM(FieldValue('RECORD_DATE',1));

Drop Table Temp;

Temp_Data:

Load *

From

[Weekly Status Report-BIICC EDW MnS - 12242010_12312010.xlsx]

(ooxml, embedded labels, table is Sheet1)

where [Actual Ackowleged Date Time] > $(vReloadDate);

Concatenate

Directory D:\Pradnya\Data\

Load *

From

..\Data\Qvd\Ticket_Log.qvd

(Qvd) where [Actual Ackowleged Date Time] < $(vReloadDate);

Store Temp_Data into ..\qvd\Ticket_Log.qvd;

Drop table Temp_Data;

Miguel_Angel_Baeyens — Wed, 09 Feb 2011 18:25:51 GMT

Hello,

Try quoting your date variable in all cases:

where [Actual Ackowleged Date Time] < '$(vReloadDate)';

Hope that helps.

topic Error message while lodind data on incremental basis in QlikView