filter data according to date while loading data via editscript

[sushil353]

hi Experts,

i want to filter out data while loading. i want to apply condition like

TIME_DATE >= TO_DATE('2010/08/15 00:00:00', 'YYYY/MM/DD HH24:MI:SS')

and

TIME_HR_DIM. TIME_DATE < TO_DATE('2011/1/25 00:00:00', 'YYYY/MM/DD HH24:MI:SS')

the upper one is a sql querry.

TIME_HR_DIM:

LOAD

"TIME_DATE"

,

"TIME_HOUR"

,

"DAY_OF_MONTH"

,

"WEEK_OF_YEAR"

,

"WEEK_STARTING_DATE"

,

"MONTH_OF_YEAR"

,

"MONTH_NAME"

,

QUARTER

,

"YEAR_OF_YEAR"

,

"HALF_YEAR"

,

"DAY_DATE"

,

"ISO_YEAR"

;

SQL

SELECT *

FROM "DW_OWNER"."TIME_HR_DIM";

THANKS

SUSHIL

"TIME_ID",

[#2]

hi your problem will solve, if u use Where clause.

Table_Name:

LOAD

"TIME_DATE",TIME_HOUR",DAY_OF_MONTH","WEEK_OF_YEAR","WEEK_STARTING_DATE","MONTH_OF_YEAR","MONTH_NAME",QUARTER,

"YEAR_OF_YEAR","HALF_YEAR",DAY_DATE","ISO_YEAR"

SQL

SELECT *

FROM "DW_OWNER"."TIME_HR_DIM"

Where

TIME_DATE >= TO_DATE('2010/08/15 00:00:00', 'YYYY/MM/DD HH24:MI:SS')

and

TIME_HR_DIM. TIME_DATE < TO_DATE('2011/1/25 00:00:00', 'YYYY/MM/DD HH24:MI:SS');

try like this..

regards

A'run'

[#3]

Hi,

We can use where clause to filter the data when we are loading through SQL database tables.

What if we are loading from the excel files kept on sharepoint website, i think Where clause doesn't work for this

Any suggestions are most welcomed

Regards,

KC