topic Re: delta load on last updated date in QlikView

delta load on last updated date

Anonymous — Sat, 15 Nov 2014 06:44:39 GMT

hi gurus,

LAST_UPDATE_DATE=01-01-2014 00:00:00 AM

i want lo load data >=LAST_UPDATE_DATE>=01-0102011 '00:00:00'.

its loading data for 2009,2010 ...2014.

its doing full load instead of delta

how to filter load when date as time stamp with Ante meridian,post meridian

thanks in advance

its_anandrjs — Sat, 15 Nov 2014 06:57:41 GMT

Hi,

Try with

Load *

From Source

Where

LAST_UPDATE_DATE >= '01-01-2011 00:00:00 AM' and LAST_UPDATE_DATE <= '01-01-2014 00:00:00 AM';

Regards

Anand

anbu1984 — Sat, 15 Nov 2014 07:24:25 GMT

What is your source?

Anonymous — Sat, 15 Nov 2014 13:00:42 GMT

oracle

anbu1984 — Sat, 15 Nov 2014 13:57:52 GMT

LAST_UPDATE_DATE>=To_date('01-01-2011 00:00:00','MM-DD-YYYY HH:MI:SS')