Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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/