topic incremental load insert only in QlikView

incremental load insert only

Fri, 27 Mar 2015 10:46:33 GMT

i made a code in incremental insert only...i have took two tables, tables name is Tab and Tab2. i have wrote 6 fields in Tab table ..

when my program execution the code is successfully shows 6 fields okay.After i am inserting new field in Tab table,the output will be shows 7 fields Tab table,but Tab2 it will shows only 6 fields..please help me i had upload my qvw file please check it.

output shows

Tab:

ID, Name, Date

1000, gcsh, 02/3/2015

1100, sdhg, 04/3/2015

1200, ysfb, 07/3/2015

1300, mchx, 08/3/2015

1400, hsdg, 12/3/2015

1500, hzfd, 17/3/2015

1600, hzfdkk, 19/3/2015

Tab2:

1000, gcsh, 02/3/2015

1100, sdhg, 04/3/2015

1200, ysfb, 07/3/2015

1300, mchx, 08/3/2015

1400, hsdg, 12/3/2015

1500, hzfd, 17/3/2015

iam looking for output

Tab:

ID, Name, Date

1000, gcsh, 02/3/2015

1100, sdhg, 04/3/2015

1200, ysfb, 07/3/2015

1300, mchx, 08/3/2015

1400, hsdg, 12/3/2015

1500, hzfd, 17/3/2015

1600, hzfdkk, 19/3/2015

Tab2:

1000, gcsh, 02/3/2015

1100, sdhg, 04/3/2015

1200, ysfb, 07/3/2015

1300, mchx, 08/3/2015

1400, hsdg, 12/3/2015

1500, hzfd, 17/3/2015

1600, hzfdkk, 19/3/2015

Re: incremental load insert only

its_anandrjs — Fri, 27 Mar 2015 11:57:15 GMT

Hi,

Try to use the Max function for finding the MAX date for the given date and then concatenate previous date by finding the maxdate you can fin d the code in the community also.

Regards

Anand

Re: incremental load insert only

Fri, 27 Mar 2015 12:41:08 GMT

hii venu

Try like this example format expression in your file

Temp:

LOAD

Max(DateFieldName) as MaxDate

Resident TableName;

LET vMaxDate = floor(peek('MaxDate'));

Drop Table TableName;

See this links also for explanation

http://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

Incremental Load in QlikView – Part1 | Learn QlikView

Incremental Load in QlikView – Part2 | Learn QlikView

http://www.quickintelligence.co.uk/qlikview-incremental-load/