how to use a variable during reloading data

[#1]

hi

I create a variable and i try to restrict the data from the DB by using WHERE close during reloading data.

Is my syntax OK ?

i attache the error message

Failures:

LOAD Serial_Number,

     Name,

     Date,

     event_recnum,

     Engine_Number,

     SW_Version,

     EndTime,

     Imps_Counter,

     Restarts_During_Recovery,

     WeekendTimeDuringFailure,

     DownTimeDuringFailureWeekend,

     DownTimeDuringFailureRegular,

     NightTimeDuringFailure,

     NightModeTimeDuringFailure,

     SpecialCustomerJobs_Imps,

     SpecialJobs_Imps,

     [RecoveryTime(seconds)],

     NullsDuringFailure

FROM

Data\iserve_Data.xlsx

(ooxml, embedded labels, table is SHARONֹFAILURES)

where Date >= $(V_max_date);

store Failures into $(path_xls)Failures.qvd;

[deepakk]

hi sharon,

You have to put the variable inside single quotes like below

where Date >= '$(V_max_date)';

Deepak

[#3]

thank you