topic Re: filter data according to date while loading data via editscript in QlikView

filter data according to date while loading data via editscript

sushil353 — Fri, 18 Mar 2011 06:56:44 GMT

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",

filter data according to date while loading data via editscript

Fri, 18 Mar 2011 08:25:55 GMT

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'

Re: filter data according to date while loading data via editscript

Mon, 13 Jul 2015 07:06:16 GMT

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,