how to use a variable during reloading data

Thu, 20 Sep 2012 07:19:22 GMT

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;

Re: how to use a variable during reloading data

deepakk — Thu, 20 Sep 2012 07:22:47 GMT

hi sharon,

You have to put the variable inside single quotes like below

where Date >= '$(V_max_date)';

Deepak

Thu, 20 Sep 2012 07:49:46 GMT

thank you