topic Re: Incremental load date issue in QlikView

Incremental load date issue

Rajesh — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to do incremental load with opened_at (Date field) in source it is like (opened_at = '2017-08-02 11:30:45.0000000').

after i doing max(opened_at) as Maxopendate; it is showing like 42949.778564819.

Please see below error i am facing while trying to only newly inserted data with usong opened_at date field,

Can any one suggest.

Thanks,

Rajesh

Re: Incremental load date issue

Chanty4u — Tue, 08 Aug 2017 09:41:17 GMT

did you tried to convert that into proper date format and do it

Re: Incremental load date issue

kaushiknsolanki — Tue, 08 Aug 2017 09:45:06 GMT

Hi,

Try converting it into a timestamp like below.

Let vDate = Timestamp(peek('Max',0','Max'),'YYYY-MM-DD hh:mm:ss');

Regards,

Kaushik Solanki

Re: Incremental load date issue

tresB — Tue, 08 Aug 2017 09:45:45 GMT

Format your variable like:

Let vTime=Timestamp(Peek('Maxopendate'), 'YYYY-MM-DD hh:mm:ss.fffffff')

Re: Incremental load date issue

gsbeaton — Tue, 08 Aug 2017 09:49:36 GMT

You are mixing date formats. You will have to convert the Qlik timestamp to match the source table time format.

Something like this: date(opened_at,'DD/MM/YYYY hh:mm:ss[.fff]')

Hope this helps.

George

Re: Incremental load date issue

Rajesh — Tue, 08 Aug 2017 10:11:24 GMT

Thanks Kaushik,

but it showing error like below

Re: Incremental load date issue

kaushiknsolanki — Tue, 08 Aug 2017 10:13:36 GMT

Hi,

Your variable should be in single quote

Where Field = '$(vVariable)';

Regards,

Kaushik Solanki

Re: Incremental load date issue

tresB — Tue, 08 Aug 2017 10:14:55 GMT

Try putting single quotes around variable like:

...

where opened_at > '$(YourVariable)' ;

Re: Incremental load date issue

Rajesh — Tue, 08 Aug 2017 10:24:09 GMT

its done now

Thank u much Kaushik.

Regards

Rajesh