topic Re: Where Clause issue in incremental loading in QlikView

Where Clause issue in incremental loading

dseelam — Wed, 02 Nov 2016 12:50:39 GMT

Hello Guys,

I am facing this issue with incremental loading guys, any suggestions

"CANCELLED_DATE" is coming from one of the views in Oracle

am using date( "CANCELLED_DATE,'MM/DD/YYYY'" ) as CANCELLED_DATE but still it is taking it as a num

Thanks in advance

Re: Where Clause issue in incremental loading

Gysbert_Wassenaar — Wed, 02 Nov 2016 13:03:48 GMT

10 divided by 31 divided by 2016 is a number. Perhaps you meant to use single quotes: '10/31/2016'. Or if oracle doesn't understand that try to_date('10/31/2016','MM/DD/YYYY')

Re: Where Clause issue in incremental loading

dseelam — Wed, 02 Nov 2016 13:41:42 GMT

Hello Gysbert,

Thanks for reply

when I use to_date('10/31/2016','MM/DD/YYYY') in where clause I got this below error

FROM APPS."XXHSP_DB_CANCELLED_LINES_V" where "CANCELLED_DATE" >to_date($('Last_Updated_Date','MM/DD/YYYY'));

if I use other way around as you told 'single quotes'

I got this error

Re: Where Clause issue in incremental loading

sunny_talwar — Wed, 02 Nov 2016 13:44:24 GMT

Try this (I think you misplaced the single quotes and the parenthesis):

ROM APPS."XXHSP_DB_CANCELLED_LINES_V" where "CANCELLED_DATE" > TO_DATE('$(Last_Updated_Date)','MM/DD/YYYY');

Re: Where Clause issue in incremental loading

gandalfgray — Wed, 02 Nov 2016 13:46:25 GMT

I think you got the quotes wrong, they should be around your date value.

Should be like this I think:

SQL SELECT * FROM APPS.XXHSP_DB_CANCELLED_LINES_V where CANCELLED_DATE>'10/31/2016'

Re: Where Clause issue in incremental loading

dseelam — Wed, 02 Nov 2016 14:24:21 GMT

Hello Sunny,

I got this doubt, Once implemented section access

there is no need to reload whole data from oracle right (initial load)

I just can start from 2nd step loading from QVD ?

Re: Where Clause issue in incremental loading

dseelam — Wed, 02 Nov 2016 14:26:44 GMT

Goran,

Thank you I got it sorted out

Re: Where Clause issue in incremental loading

sunny_talwar — Wed, 02 Nov 2016 14:29:34 GMT

If you have stored the data in a qvd and you think that it doesn't need to be updated, then sure you can load from QVD

Re: Where Clause issue in incremental loading

dseelam — Wed, 02 Nov 2016 14:35:05 GMT

Yes whole data is stored in form of QVD in initial load after that I just bring data with last updated date, concatenating with existing QVD where ID not exists and Inner joining with ID's and storing them in QVD which should store the data right ?

Re: Where Clause issue in incremental loading

sunny_talwar — Wed, 02 Nov 2016 14:40:01 GMT

Seems like you are doing an incremental load. If you are doing it right, then ya, you should be able to pull data from your qvd

Re: Where Clause issue in incremental loading

dseelam — Wed, 02 Nov 2016 14:43:45 GMT

Thanks Sunny