Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

incremental load insert only

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

2 Replies
its_anandrjs

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

Not applicable
Author

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/