topic Re: where clause in the script in QlikView

where clause in the script

Sun, 15 Sep 2013 09:58:11 GMT

i want to user where clause in the edit script -(3 process)

1.read from text file (date wise file 1/1/2010...10/1/2010- i want to laod only 5 to 10)

2.use date weteen clause(5-10)

3.use not exists clause to laod only (5-10)

Re: where clause in the script

Miguel_Angel_Baeyens — Sun, 15 Sep 2013 10:35:05 GMT

Hi,

I don't quite understand if you want to do all three steps, or either of any three... You can load from a text file to get only some dates using the following:

WHERE Date >= '05/01/2010' AND Date <= '10/01/2010'

Make sure the Date field is a numeric field.

Hope that helps.

Miguel

Re: where clause in the script

Sun, 15 Sep 2013 11:17:45 GMT

i am new in this qlik view so i want to know how to use where clause-

1.if i am loading data from text file(date wise file stored)

2.already you explained

3.use not exist cluse(suppose i have loaded upto 4th i want to laod 5 to 10) it could be similar like 2

Re: where clause in the script

Sun, 15 Sep 2013 17:46:47 GMT

please help

Re: where clause in the script

Mon, 16 Sep 2013 05:35:23 GMT

Hello,

I think you need incremental load, based upon your date range.

http://community.qlik.com/message/279669#279669

Thanks,

ASINGH

Re: where clause in the script

narender123 — Mon, 16 Sep 2013 06:40:49 GMT

Hi,

you can use where cluase as

eg:

Load * inline[

id,date

1,15/01/2010

2,16/01/2010

3,17/01/2010

4,18/01/2010

] where date >= '15/01/2010' and date <= '17/01/2010' ;

Not Exist:

eg:

LOAD * INLINE [

id,name

1, dk

2,cck

3,ab

4,cd

]Where not Exists(id);

Thanks