Discussion Board for collaboration on QlikView Scripting.
I am doing incremental load and I want to delete current month data in that load. I have to do it where clause, but how to include that condition where clause before doing STORE command. Please give me suggestions.
you need to update the condition in the main table you cannot have a where clause in the store statement
Try like this :
incrimental statements ;
create a resident table with table with the where clause and use the same in the store statement
can we do sth like:
from YourTable where num(month(Date))<>(Not Equal to)num(Month(Today()))
Thanks for your reply. Here date is coming from column DW_load_date. So CAn you tellme how do i include this month here.
replace Date with DW_load_date
just editing it:
date(Date,'DD/MMM/YYYY') as Date,
from YourTable where num(month(Date))<>(Not Equal to)num(Month(date(Today(),'DD/MMM/YYYY')))
If my data is not today, then it will give me wrong results?
Today only or not have for full today month??
if today only, no worry.
But if you are not having data of November, you would not be able to check whether its working or not
if would you like to make easy your job you can use the library RobWunderlich/Qlikview-Components · GitHub that contains all you need to do better incremental load.
I you want to delete record from a table you have to use inner join with a temp table where exists some fields with value that you that to mantain.
Luca Jonathan Panetta