Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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/