topic Re: Incremental load prob in QlikView

Incremental load prob

nikhilgarg — Wed, 02 Sep 2015 13:09:03 GMT

Hey,

I am trying to implement the incremental load but for incremental tab , i should get final table containing data whose date > vMaxdate.

But i ma getting whole data.

Can someone looks into it. I have attached app and excel with it.

Thanks

Re: Incremental load prob

Anonymous — Wed, 02 Sep 2015 13:35:29 GMT

LOAD Id,

Name,

Age,

Date

FROM

(ooxml, embedded labels, table is Sheet1)

Where Date> $(vMaxDate);

vMaxDate =Date('25-08-2015') in variable overview.

It'll fetch only one record .

Thanks

Re: Incremental load prob

xavieravinson — Wed, 02 Sep 2015 13:39:34 GMT

Hi,

Please check the application,

In Peek you were using table2 and table3.

you are using resident If all the fields are same it will automatically concatenate.

I have Created a Junk. Check the application.

Re: Incremental load prob

nikhilgarg — Wed, 02 Sep 2015 14:05:56 GMT

Hi ,

Thanks for your reply but i don't understand why you commented out Tranformation script.

Also, in my file for incremental Table i ma getting whole data instead of only daya matching condition:

where Date > $(vMaxDate)

bcoz , $(vMaxDate) is giving value 1992 and not 2015-09-14. And vMaxDate gives 2015-09-14.

But when i use condition:

where Date > vMaxDate ; it is giving error that vMaxDate field not found

Is there way to rectify this ?

Re: Incremental load prob

nikhilgarg — Wed, 02 Sep 2015 14:06:20 GMT

Hi ,

Thanks for your reply .

But, in my file for incremental Table i ma getting whole data instead of only daya matching condition:

where Date > $(vMaxDate)

bcoz , $(vMaxDate) is giving value 1992 and not 2015-09-14. And vMaxDate gives 2015-09-14.

But when i use condition:

where Date > vMaxDate ; it is giving error that vMaxDate field not found

Is there way to rectify this ?

Re: Incremental load prob

nikhilgarg — Wed, 02 Sep 2015 14:24:27 GMT

Hey,

Now it is working fine as i have used:

where Date > '$(vMaxDate)'

Thanks

Re: Incremental load prob

nikhilgarg — Wed, 02 Sep 2015 14:24:35 GMT

Hey,

Now it is working fine as i have used:

where Date > '$(vMaxDate)'

Thanks

Re: Incremental load prob

Anonymous — Thu, 03 Sep 2015 05:03:53 GMT

Hi NikhilGarg,

You mentioned that you have problem in incremental load tab so i worked on the same tab.

Thanks

Re: Incremental load prob

xavieravinson — Thu, 03 Sep 2015 05:07:58 GMT

I think your data in excel sheet is in text format.

Thanks & Regards,

XavieRavinson